LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I stop my program after it finishes reading a spreadsheet?

I'm reading data from a spreadsheet that has 2 columns and a variable amount of rows. I want my program to stop when it runs out of numbers to read. I've attached what I have so far, can someone help me?
Download All
0 Kudos
Message 1 of 4
(2,856 Views)
The "Read From Spreadsheet File.vi" reads only text data, not from an Excel spreadsheet file (as the name might imply). You need to use Active X to invoke and read directly from a spreadsheet. It's not too tough if you've got examples.

Check out the following thread. It's got some examples:

http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=50650000000800000035480000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0&USEARCHCONTEXT_QUESTION_0=read+from+excel&USEARCHCONTEXT_QUESTION_S=0

~Tim
0 Kudos
Message 2 of 4
(2,856 Views)
hi

I do not see the need for stopping the read operation of your spreadsheet-file; this functionality is included in "Read from Spreadsheet file.vi" - use it like shown in your changed vi. I would suggest to save your Data in .txt-file. Test the attached vi's.

regards
wha
Download All
0 Kudos
Message 3 of 4
(2,856 Views)
Thanks guess I was just making it more complicated than it needed to be.
0 Kudos
Message 4 of 4
(2,856 Views)