How to read columns one by one from spreadsheet file

[oruganti]

Hi

I am working on hydraulic test system control.I need to input my command from excel file point by point.any body now how to input from excel file pls help me.

regards

oruganti.

[becktho]

Hi

What do you mean with "from excel file point by point"?

How is this excel file generated?

Thomas

[Tim.S]

The simplest way is to save your Excel data as a csv (comma separated variable) file or tab separated txt file.

Then you can use the "read from spreadsheet file.vi" to pull the data into an array.  After you have it in a LabVIEW array, you can maninulate it with the array tools (pull out a row or column at a time, pull out specific values, etc...).