LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Is there anyway to read alpha-numeric data from spreadsheets?

I am not only talking about headers, but entire columns of text data. I need find a way to read from a .xls file that contains both text and numbers and display it on screen, in a table.
0 Kudos
Message 1 of 3
(2,604 Views)
Hi,
you should use activeX to read from XLS spreadsheet.

You can find here an example:
http://zone.ni.com/devzone/explprog.nsf/6c163603265406328625682a006ed37d/fdbbd2bba6084d9b86256682005e9758?OpenDocument

Good luck,

Alberto
Message 2 of 3
(2,604 Views)
Trojan:

Your best bet is to use the Scan String function, using the string format. This is compatible with the C++ "scanf" function. You can parse the data any way you like.

By the way, I haven't heard the rest of the story on your positioning servo contoller. How's the PWM circuit working out?

chutla the Bruin :=)
Eric P. Nichols
P.O. Box 56235
North Pole, AK 99705
0 Kudos
Message 3 of 3
(2,604 Views)