Error loading type library/DLL (Microsoft.Office.Interop.Excel.Application)

visual-studio-2012 ms-office office-interop office-2013
Ned picture Ned · Jan 1, 2013 · Viewed 12.2k times · Source

I'm trying to create an Excel document via C#. When I run the application, it gives the following error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

enter image description here

It was working fine before I've upgraded Visual Studio from 2010 to 2012. I've also upgraded Office from 2010 to 2013.

  • There are no errors/warnings at output window.
  • Microsoft.Office.Interop.Excel reference is added

Answer

Ned picture Ned · Jan 2, 2013

I was struggling with this error for a few days . I've finally found the solution.

It occurs because I’ve installed Office 2013 instead of Office 2010 which I was using with old version of my project. After I upgraded my Office, the project was no longer able to link Excel reference.

Even though I referenced new Excel library which is 15.0, it didn't work.

What I did is that:

  • Delete the Excel reference (Microsoft.Office.Interop.Excel). Version 15.0, in my case.
  • Install Microsoft Excel (whichever version you had been using. Version 2010 for me)
  • Add the Excel reference (older one. Version 14.0, in my case)

Related questions

Can't locate Microsoft.Office.Interop.Word in Reference List

I was given this solution to a problem I had, since I didn't know how to integrate MS Word with C#: http://www.dotnetperls.com/word I looked into this solution, and I can't locate Microsoft.Office.Interop.Word in …

Read More
Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More
Is there a format code shortcut for Visual Studio?

In Eclipse there is a shortcut, Ctrl+Shift+F, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

Read More