Load 2D excel array

[Misere]

Hi,

I'm trying to write and analysis application for a university project.  First step is to load a 2D excel array which I can't do.  The array is data from several different experiments stored on a single excel spread sheet.  Thus, the data of importance in stored in columns and each column is a different length (2000-7000 data points).  What I want to do is

Load the 2D array

Read the first column

Read the header row (text string)

Exact the data (second row to last row with data for that column, number data)

Perform the analysis

Spit out the result tagged to the header name

Move onto the next row

So:

Is it possible to do this in lab view?

How do I load an excel file into lab view that has text and numeral data?

 Josh

[RayFarmer]

Hi,

You would get a bigger response if you posted to the correct forum, ie LabVIEW, as this is the TestStand forum

When you repost, say what version of labVIEW your using.

Maybe post an example of the spreadsheet.

Finially, Yes anything is possible in LabVIEW, just depends on how much you are willing to spend

Regards

Ray Farmer

[Joe_H]

Yes josh you can do this quite easily in Labview. Have a look at the excel board here on the forums in the breakpoint. Also have a look at the examples in LV there is one in their called write to table.vi or something along those lines.

Labview does not natively talk to Excel. You must use active X. NI sells a toolkit for doing this. But if you do not have it then you do not have to buy it. there is a lot of examples and even some free toolkits on the excel board.

For more information and some sample VI's and tool kits, you can go to the excel board

Enjoy and if you have any more questions please post back. Also next time please post LabVIEW questions to the LabVIEW board.