Application crashes opening the Excel file

[parissa_wall3]

I built an application that needs to open an Excel file and read the data from. it works fine on my system, but when I run it on another PC, it crashes and give an error which I attached.

is it because of the version of the file?

[nyc_(is_out_of_here)]

---

@parissa_wall3 wrote:

I built an application that needs to open an Excel file and read the data from. it works fine on my system, but when I run it on another PC, it crashes and give an error which I attached.

is it because of the version of the file?

---

I don't see any graphic file showing the error in the zip file you included.

[RTSLVU]

I have found using ActiveX for Excel automation unreliable at best due to differences in Windows, ActiveX, and Excel versions.

This forum and the Idea Exchange is full of examples that read and write Excel files through ActiveX and I have tried many of them

They all might work flawlessly on one computer and never work on another seemingly identical computer. 

I have been looking at XLR8 Excel Toolkit and it looks promising since it does not require Excel to be installed on the target machine and does not use ActiveX automation.

[parissa_wall3]

Here is the error. 

[RTSLVU]

Yup that's the error I always got.

I even workd with a NI engineer for several days trying to figure out why it works fine on one computer but another computer gives that error.

We never figured it out and we have abandoned this method of Excel automation

[Bob_Schor]

You appear to be running LabVIEW 2014.  Do you have the Report Generation Toolkit (included automatically with LabVIEW 2014 Professional)?  If so, it is a whole lot easier to use, it (mostly) works, and it does not require you to use ActiveX, which I believe even Microsoft has abandoned.  If you do have the toolkit, please try it, it will make your programming a lot easier (and result in many fewer errors).

Bob Schor

[parissa_wall3]

I have 2014 and I have report generation toolkit for the next 30 days.Does the toolkit it have a read from Excel option? for some reason I couldnt find it.

[RTSLVU]

---

@parissa_wall3 wrote:

I have 2014 and I have report generation toolkit for the next 30 days.Does the toolkit it have a read from Excel option? for some reason I couldnt find it.

---

If you are workign with demo software then you might as well use the XLR8 Excel Toolkit I recomended before.

[Bob_Schor]

Open the Report Generation Toolkit.  Find "New Report", and look at its Help.  Do you notice the required Report Type input?  One of the options is Excel.

This would be a very good time to mention that there are Examples and Tutorials out there that will show you the basics.  I wrote one myself, but have always had a problem linking to it ... let me see if I can find it.  Hmm, if you search here for Revised "Generate Excel Report" Example (the quotes are part of the title), you'll find my revision, fully commented, of the Generate Excel Report that ships with LabVIEW.

Bob Schor

[parissa_wall3]

thanks for the solutions, I tried the XLR8 Excel Toolkit , It looks solid, but when I run my program it gies me this error:

rror 1172 occurred at Invoke Node , (System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
Inner Exception: System.NullReferenceException: Object reference not set to an instance of an object.)

LabVIEW: A .NET exception occurred in an external assembly. For information about correcting this error, copy the following exception (in bold), and search the Microsoft Developer Network (MSDN) Web site or the Web for a possible explanation.
System.NullReferenceException in XLR8.lvlib:Read Area (String).vi->Main EPL Task.vi