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

Question

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?

Nilesh Shah · Answer

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.

Nepethya Rana · Answer

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 ?