LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to export data from excel to VI

Hello

 

I have acquired a waveform and exported it to a excel spreadsheet. I would like to export this data into the VI I am working on value by value, column by column.

 

My aim is to compare these set of values with ones that I am currently acquiring.

 

Thanks

 

0 Kudos
Message 1 of 4
(3,039 Views)

Did you try reading the spreadsheet with the "Read from Spreadsheet.vi"?

-----

The best solution is the one you find it by yourself
0 Kudos
Message 2 of 4
(3,029 Views)

You need to save your excel file in .csv format. Then you can read it in with the read from spreadsheet vi or the read text file vi if you want more flexibility (eg. if it contains string values too).

0 Kudos
Message 3 of 4
(3,012 Views)

Hi,

 

In labview examples folder, you have in examples/comm/ExcelExamples.llb Exel examples and function.

 

Take a look at set "Set Cell Value". Normally you only have to copy the file and change Range/value2 to read.

 

Yoann

0 Kudos
Message 4 of 4
(2,996 Views)