Excel to LabView array

[jimbo50]

I need to load data from several excel spreadsheets into a large 2D array.

Here is what I am trying to do

1. Open an Excel file

2. Save the Excel file to a .csv -  How can I open excel spreadsheets in LabView and save to .csv files.

3. Close the Excel file

4. Use spreadsheet to array VI to get data

5. Append data to my array.

I have not figured out how to do step 2.

Is there an easier way to do this?

[RavensFan]

The easier way would be to use ActiveX methods to open the Excel file and read the data directly from it.  Search the forums for ActiveX and Excel.  Also look in the Example Finder for Excel examples.

There is also a message thread on Breakpoint which is a repository of links to interesting Excel threads.

Message Edited by Ravens Fan on 10-06-2009 09:12 PM

[Harold_Timmis]

if you type in excel in example finder you will find the

Excel Macro Example, and write table to XL these should help you.

[aeastet]

If you open the zip file that I attached what I did should get you close. It will get you a starting point. I am not sure why you were saving as csv but if you need to do that you could add that to this. You need to populate the path array with all of the file locations and tell the program where the data is located for each file. I hope this helps.

[aeastet]

Here is the zip file forget the attachment

[aeastet]

Hi Jimbo50,

I was wondering if this helped or if you needed more info?