LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

query an excel file using CVI

I need to query an excel file and load values contained in the cells into variables using CVI, I am not sure how to do this.  I have attached a sample xls file, there is a header row, which the first column is the lookup string.  Once I have found the lookup string, I want to read each value in the row into a seperate variable, or even an array.
 
Thanks in advance,
Dan
0 Kudos
Message 1 of 2
(3,102 Views)

CVI can interact with Excel via ActiveX and read / write data to a spreadsheet this way.

I suggest you look into the samples shipped with CVI to find those related to ActiveX in general and Excel in particular: they are a good starting point to begin building your application.



Proud to use LW/CVI from 3.1 on.

My contributions to the Developer Community
________________________________________
If I have helped you, why not giving me a kudos?
0 Kudos
Message 2 of 2
(3,083 Views)