Error -2147312566:: Excel 2013, LV2015

[rajamodol]

Hi everyone,

I know this topic has been discussed long time ago. I have tried the solution, but it didn't work, and i have no idea how to proceed.

My Testsystem has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2010

My PC has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2013

When i execute this VI:
C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\Connectivity\Excel\Excel - Write Table.vi

My Testsystem has no problem. It works well.

My PC said:

Our IT would probably update Office 2010 into Office 2013. I have been fighting with this issue since 1-2 days with no result.

Could anyone please tell me what i should do to solve this issue?

THanks,

Rajamodol

[billko]

---

@rajamodol wrote:

Hi everyone,

I know this topic has been discussed long time ago. I have tried the solution, but it didn't work, and i have no idea how to proceed.

My Testsystem has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2010

My PC has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2013

When i execute this VI:
C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\Connectivity\Excel\Excel - Write Table.vi

My Testsystem has no problem. It works well.

My PC said:

Our IT would probably update Office 2010 into Office 2013. I have been fighting with this issue since 1-2 days with no result.

Could anyone please tell me what i should do to solve this issue?

THanks,

Rajamodol

---

All the Google searches I have done on this error indicate that not only is it not a LabVIEW error - and not even a MS Office-specific error.  Rather, it seems that this is a generic error that has something to do with .dll registration.

Being that it does seem to be a LabVIEW tool kit that is prodcuing this error, maybe it needs to be repaired?  Maybe the wrong version of the tool kit is installed?  (It doesn't look like an English install to me.)

[Bob_Schor]

---

@rajamodol wrote:

My Testsystem has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2010

My PC has:

- LabVIEW 2015 SP1+Report Generation Toolkit

- Office 2013

When i execute this VI:
C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\Connectivity\Excel\Excel - Write Table.vi

---

When I first read this, I thought "Oh, it's a problem with Office 2013".  My Work PC  has Windows 7 (x64), Office 10, and LabVIEW 2015 SP1 (32-bit), while my home PC has Windows 10, Office 2013, but LabVIEW 2016.  I'm home, so decided to try it here.

Then I realized "The Question was Wrong".  The "correct" question is "Why did NI put this Example out there when you can do the same thing with four functions using the Report Generation Toolkit?".

I'm also attaching the Excel file it created (which mimics the Table on the Front Panel).  Took me about 5 minutes to code (and test) this ...

Bob Schor 

[rajamodol]

Hi Bob,

it means that, you have no issue when executing this vi?
C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\Connectivity\Excel\Excel - Write Table.vi

I'm wondering, if i have to reinstall LV or Office..

Regards,

Rajamodol

[rajamodol]

Hi All,

I have reinstalled LabVIEW 2015 SP1, unfortunately didn't help anything.
I have created small vi, just to localize the root cause.

Error -2147312566 didn't occurs while i have pointed  Excel._Application ref to version 1.8 (Excel 2013).

But Error 3005 occurs, mentioned that:
Error 3005 occurred at Automation Open: Object specified is not creatable in Test_ReadExcelVersion.vi

Is there anything i forgot? any idea why i can't call Microsoft Excel 15.0 Object Library Version 1.8?

This is what i have on registry.

Everything seems to be fine. If someone has an idea, i would like to know it... Thanks so much!

Regards,
Rajamodol

[rajamodol]

Well, just small update.

Eventhough i have selected "Createable Objects Only", old error re-occured again.

Still no idea why.

Any help would be very very appreciated!

Regards,

Rajamodol

[rajamodol · Accepted solution]

Well,

Case closed!
I have repaired Excel 2013 (It is actually MS Office 365ProPlus).
Somehow, office updated itself and probably leads to some conflict.. no idea what. But, after repaired it, seems all back to normal.

Calling the following exampe, generates no error!
C:\Program Files (x86)\National Instruments\LabVIEW 2015\examples\Connectivity\Excel\Excel - Write Table.vi

Thanks All!
Rajamodol

[billko]

Sorry you had to figure it out yourself - but thanks for posting the solution in case anyone else has the issue!  🙂

[rajamodol]

Hi Bill,

that's part of the game... 😉

Regards,

Rajamodol

[fabbro12]

How did you solve the problem? I have exactly the same issue...