Our Training Programs

All contents are copyright of their authors.

System.Runtime.InteropServices.COMException (0x80040154):

System.Runtime.InteropServices.COMException (0x80040154):

Nepethya Rana

9yAsked Feb 7, 2017, 11:06 AM9.6kOffice Development

My 64 bit server which is running 32 bit office,

what my application does is get the data and create a excel file in server.

I am getting this error :

System.Runtime.InteropServices.COMException (0x80040154):

Retrieving the COM class factory for component with CLSID {xxx-xx-xxxx}

failed due to the following error: 80040154.

I checked in GAC in my server, its missing MIcrosoft.Office.Interop.Excel.

How do i fix this issue?

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Nepethya Rana9y ago
I can do it in local, dev environment where i can get package to install from Nuget, I looked into my GAC in my local machine, it did my mentioned dll and app runs and works as it is supposed to do. I take the exe thus created and tried to execute in server, it throws the error as in my server, i dont have MIcrosoft.Office.Interop.Excel in GAC. is there a way where i can copy this dll and keep it in app folder ?
Nilesh Shah9y ago
I faced this issue many times in my last project while dealing with importing excel files.

You need to add reference to excel which can be found here:
http://stackoverflow.com/questions/15285880/how-to-reference-microsoft-office-interop-excel-dll

but there is also nuget package available for excel interop which is much more easy then the above.