From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

read Excel data

Hi All,

 

I have an excel sheet and I want to read a particular data from that sheet and then I want to get its cell coo-rdinates.Is it possible if yes please tell me the solution. 

0 Kudos
Message 1 of 2
(2,693 Views)

Hello Arpit Jain,

CVI comes wih an interface to Excel that you can use in your own projects. I suggest you take a look at the example <CVI Sample folder>\ActiveX\Excel\Excel2000dem.prj which just shows you how to read / write into an Excel sheed in several ways. This example makes use of the Microsoft Excel 9.0 Object Library instrument that is located in <CVI folder>\toolslib\activex\excel folder.

There are a lot of forum posts related to this instrument which you can look at to have some guidance on its usage.

 

Just for completeness, CVI comes with an addigional instrument (ExcelReport.fp) which is aimed to using Excel for report generation: this instrument too permits reading / writing to Excel sheets but I have rarely used it so I cannot be of much help in case you want to use it instead of the first one.



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
(2,692 Views)