Read from Excel

[SaNoSuke]

Hi,

I'm a new user in LabView and doing a project, i would like to know how can i read from two dimensional array in excel sheet (or table) into labview?

means i can specify the column and the row from t he labview then read the value from excel ( or sometimes more than one value a time)

Regards,

M.B

[PaulL]

QUOTE (SaNoSuke @ Mar 24 2009, 09:43 AM)

Hi,

I'm a new user in LabView and doing a project, i would like to know how can i read from two dimensional array in excel sheet (or table) into labview?

means i can specify the column and the row from t he labview then read the value from excel ( or sometimes more than one value a time)

Regards,

M.B

The "Read From Spreadsheet File.vi" on the File I/O palette should get you there.

[Mark Smith]

QUOTE (Paul_at_Lowell @ Mar 24 2009, 11:03 AM)

The "Read From Spreadsheet File.vi" on the File I/O palette should get you there.

I don't think you can use Read from Spreadsheet File on an Excel file - you'll have to save the Excel file as a csv or some other text format first. If you want to read directly from an XLS file, you'll have to use the activeX interface.

http://zone.ni.com/devzone/cda/epd/p/id/3409

Mark

Edit: added link

[jhoskins]

QUOTE (mesmith @ Mar 24 2009, 12:26 PM)

I don't think you can use Read from Spreadsheet File on an Excel file - you'll have to save the Excel file as a csv or some other text format first. If you want to read directly from an XLS file, you'll have to use the activeX interface.

http://zone.ni.com/devzone/cda/epd/p/id/3409

Mark

Edit: added link

Also for more information about using labview with Excel you can have a look at the example called Write table to Excel. you can find the example by using the example finder.

You can also have at look at the Excel thread. :thumbup:

[SaNoSuke]

Hi,

thanks a lot guys (Paul at Lowell, mesmith and jhoskins) for your reply's, am working on the solutions given by you, but i have a new issue now, how could i send two counter outputs (two pulses) in the same time if am using the DAQ card(i forgot the number of the card but it comes with one Digital I/O) ?

Cause am trying to control stepper motor through driving circuit that it needs two inputs : first for the number of steps , second for the direction, and if i kept the direction input floating the stepper will move forward and backward ...........