Excel Interop Error

Bug Finder

11y1.3kC#

Hi All,

For ne of my application, i need to generate excel sheet. for this i am using Microsoft.office.Interop.Excel reference and those methods. In my local system i have Excel installed so didn't get any issue and build succeed.

But in my client environment Excel not there and when i am running the code, its throwing exception as "The system could not find the specified file 'Microsoft.office.Interop.Excel,Version = 14.0.0.0, culture = neutral" .

How can i resolve this error without installing the Excel in server. Do i have any other methods which resolve this issue without Installation.

Even i added below one in config file, but still throwing exception.

Please check and provide me the best solution which helps me to overcome the error.

4 Replies

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

Upendra Pratap Shahi11y ago
Kindly check the version of DLL and working environment both.
This resolve your issue.
Vipul Malhotra11y ago
Hi Venky You would have to have Ms Office installed on the server in order to do it. There are way arounds like using EP Plus dll oto get the work done
Manas Mohapatra11y ago
Hi Venky,

Please make sure you added reference of correct version. Just go to references and right click on Excel.dll check version.

Please see attached image.

If it is not resolving delete code from web.config and delete interop reference. And add it again.
Raja T11y ago
Hi Venky, checkout below urls

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1da12578-a745-4254-99d5-76da7ef688f8/could-not-load-file-or-assembly-microsoftofficeinteropexcel-version14000?forum=sqlintegrationservices

http://www.codeproject.com/Questions/414712/Could-not-load-file-or-assembly-office-Versionequa?tab=mostrecent

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5fe14655-2157-4dde-843d-d8b4223ce59b/could-not-load-file-or-assembly-microsoftofficeinteropexcel-in-ssis?forum=sqlintegrationservices