How to read .xls in Labview 7.1

[NI_7]

How to read excel file using Labvie 7.1?

[altenbach]

Open your example finder and search for "excel". See how far you get. 🙂

[Joe_H]

Well if you look in the examples you will see a couple of examples. If it a true xls file you must use ActiveX to talk to excel. If you have the report generatio toolkit from NI it will not be to bad if you do not then you will have to code the functionality. If you would have searched on excel before posting you would have found numerous topics about it on this site.

For more information and some sample VI's and tool kits, you can go to the excel board

[mikeporter]

One thing to bear in mind is that the communications/control mechanism involved is ActiveX. The problem is that MS has exhibited a tendency to muck around with the interface to Excel when doing an upgrade. Worse, the mucking around has in the past resulted in changes that were guaranteed to break existing applications calling Excel.

Just something to remember for possible future reference.

Mike...

[NI_7]

I tried to run examples and sample vi, from excel forum. But I guess they are in Labview 8.0 and higher versions so when I try to run them using Labview 7.1, it gives error code-9 .

I also tried read from spreadshit.vi but I am not able to plot a graph. 😞

Thanks,

Nidhi

[shoneill]

"I also tried read from spreadshit.vi but I am not able to plot a graph. :-("

My MS sentiments exactly.

Seriously though, you need Excel installed to be able to use the examples, and as already pointed out, if you have the wrong version, it won't work....

Shane.

[BillMe]

Just how thin can you spread.....errr...nm.

Message Edited by Bill@NGC on 05-13-2007 03:58 PM

[Caseyw]

I agree with altenbach; the shipping examples in LabVIEW 7.1 should be the best place for you to get started accessing Excel files through ActiveX. In LabVIEW, click on Help >> Find Examples to open the Example Finder. Selec the "Search" tab and type in "excel" to bring up several sample applications that demonstrate the basics of LabVIEW <> Excel communication via ActiveX.

As Joe mentioned, accessing your Excel file may be easier if you have access to the Report Generation Toolkit. Basically, this toolkit adds Excel communication VIs to your LabVIEW palette to abstract away the details of ActiveX programming.

I hope this helps!

Casey Weltzin

Applications Engineer

National Instruments

[nyc_(is_out_of_here)]

---

@mikeporter wrote:
One thing to bear in mind is that the communications/control mechanism involved is ActiveX. The problem is that MS has exhibited a tendency to muck around with the interface to Excel when doing an upgrade. Worse, the mucking around has in the past resulted in changes that were guaranteed to break existing applications calling Excel.

Just something to remember for possible future reference.

Mike...

---

So, true!

Some of our computers had Excel 2000 and some had Excel 2003.
Simple code for opening Excel file using ActiveX of Excel 2000 would not work for Excel 2003.