Copy Excel Data into Labview

[Engbrecht]

I have a labview application in which I would like to be able to cut an paste a small array of data (< 100 numbers) from an excel spreadsheet and paste it into a Labview array. Reading in data from a spreadsheet file is not flexible enough for my purposes. Is there any way to accomplish this in labview.

[Evan]

Take a look at the example that ships with LabVIEW "Write Table to Excel" which you can find by searching for "excel" in the example finder. This VI takes a table and writes it to an excel sheet. You can easily modify it to read back the data rather than writing it. Basically change the property node in the Set Cell Value VI from a write to a read node and convert the variant to a string.

In addition you can modify it to open up connections to a specific file rather than to a new one.