ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

i want to read data from spread sheet?

i want to read data from spread sheet?
please help
0 Kudos
Message 1 of 3
(2,650 Views)
Use Read From Spreadshee File.vi
Search LV help, many examples for reading/writing to spreadsheets in numerous formats.
~~~~~~~~~~~~~~~~~~~~~~~~~~
"It’s the questions that drive us.”
~~~~~~~~~~~~~~~~~~~~~~~~~~
0 Kudos
Message 2 of 3
(2,643 Views)
Reading directly from a binary excel file (I'm assuming that is the spreadhseet app you are using), is fairly involved. It can be done, and there is source code available from the open-office project to guide you. As Analog implied, if you were to save your spreadsheet (save a copy) as a text file, it is really easy to read it in. However, that instance of the spreadsheet will lack equations, sheets, and any of your graphs.

Sheldon
Technical geek, engineer, research scientist, biodegradable...
0 Kudos
Message 3 of 3
(2,626 Views)