Importing rows and columns from Excel to Cluster and Array in Labview

[Omoba]

An excel table consist of  4 columns and variable number of rows, the first column is the position number and the other 3 columns are series of coordinates (X,Y,Z). I would like to import the excel table into Labview such that each row in the table will form a cluster which consist of the position number and the coordinates of each position and each formed cluster should converted to a 1D-Array(double).

I would be glad if someone can tell me the best way to go about this or better still show me some examples because i am very new in Labview.

Thanks

Omoba

[F._Schubert]

The easy way would be to save the excel file as csv (colon seperated values) and load it into ascii via load spreadsheet file (use ; as delimiter).

The more advanced way is to interface excel via ActiveX. Use the example finder and search for ActiveX to find some examples that interface excel (they should be shipped with LabVIEW).

Post back if you have more detailed questions. 

Felix 

[RDR]

Do you have the MS Office Report Generation Toolkit or are you working with the core set of LabVIEW VIs?

[Omoba]

I am working with the core set of Labview VI's

[aeastet]

You should look through this fourm. It has all kinds of help for Excel.

http://forums.ni.com/ni/board/message?board.id=BreakPoint&thread.id=2391

[Marcus Flohr]

Hey Omoba,

is your Problem allready solved or do you need additional help ?

regards, Marcus

[Marcus Flohr]

Another thing you can try is to save your excel file as a txt dokument. Than you can simply read the data witch "read spreadsheet.vi"

[Omoba]

Thanks Marcus,

but my probelm is not just reading from worksheet or from text file, this gives me a 2D-array, but what i need is to have every row formed to a cluster and the series of clusters should be converted to a 1D- array.

[Marcus Flohr]

Like this ?

[Marcus Flohr]

Hello Omoba,

i just want to check on you Problem.. did the example solve your problem?