don laugh at me

[jaw]

hi all i got a question hope u all wont laugh at me. i like to ask is labview able to capture data from microsoft excel and use the data to do some programming??? plaease advice. thanks alot :worship:

[Ton Plomp]

hi all i got a question hope u all wont laugh at me. i like to ask is labview able to capture data from microsoft excel and use the data to do some programming??? plaease advice. thanks alot :worship:

No laughs here, yes it is possible. There are 2 options (the easy expensive and the difficult cheap)

Buy the report toolkit.

Make your own toolkit.

BOth make use of the excel activex software. It is possible to do but it is very hard.

Ton

[Aitor Solar]

I don't think it's so hard, in fact. You have an example in LabVIEW (Help -> Find Example -> Communicating with external application -> Excel) and the library it uses. All is based in opening an Excel ActiveX object and operating its methods and properties.

Saludos,

Aitor

[Guest terminator]

You COULD save the excel file as .txt and open that file with the Labview open spreadsheet vi. Depends on what's in the excel file, how often you need to do this, etc.

[i2dx]

Maybe this example helps you out ...

it's originaly for writing data into excel, but the basic know how, how to access the tables and cells, is allready in there. you simpley have to change the write funktionality into a ready functionality. In fact it's easyer to read the data, then to write the data.

Unluckily I don't have a read example yet, but I hope it can give you a clue, how it works.

[VDB]

Or have a look at:

http://sine.ni.com/apps/utf8/niepd_web_dis...034080020E74861

VDB