how to use read from spreadsheet file

[xq]

i am new in using labview. i encounter a problem on how to read data from .xls file with multiple of sheets, and place the data into a 2D array.thanks

[siavakhsh]

Hi

If you go to the REPORT plate and check for EXCEL specific VIs then you can find a function that obtains the current worksheet data. You can use that several times to obtain whole set of data that is stored in various worksheets in a single file.


Kind Regards

[Dennis_Knutson]

The function is Read From Spreadsheet and not Read From Excel. You can save your .xls file as a comma or tab separated file and then the function will work. Or, you can use ActiveX to read a native Excel file. If you search the forum or NI's example programs, you'll find a lot of Excel examples.

[siavakhsh]

Hi

http://zone.ni.com/devzone/devzone.nsf/webcategories/A50386FBB21ECC1A86256AB7006C2E6C

through here or the forum you can find resources relating your inquiery.

Kind Regards

[siavakhsh]

Sorry for the mix up

This is the correct link

http://zone.ni.com/devzone/devzone.nsf/webcategories/C3E56C69D399361E86256AB7006A9149