CompletIT Community Server

I am experiencing a problem when trying to export a grid contain to an Excel file. This was working before but now is no longer working.

When I try to export to an excel file I get the following message:

Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=10.0.4504.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Office is sintalled and I suspect that it started to happens after I added some code as suggested by your support team in the following post: http://completit.com/communityserver/forums/permalink/3230/3230/ShowThread.aspx#3230.

Please advice

Regards 

 

Hi willyvidable,

In order to have the export to Excel working you have to ensure that the three files ‘Microsoft.Office.Interop.Excel.dll’, ‘Microsoft.Vbe.Interop.dll’ and ‘Office.dll’ are located in the same client's folder where the main assembly ‘DataGridViewExtension.dll’ is. If you use OneClick deployment make sure you deploy also the three files mentioned above.

If you have questions do not hesitate to contact us.

Sincerely Yours
Support Team

It works fine when I add the reference to those DLLs. Thanks for the answer.

Hi,

I am also getting exporting error related to the "Microsoft.Office.Interop.Excel.dll" not being found. I have the extension installed on a portable drive and added the references to my project. Do I have to add these assemblies to the GAC?

kpenigar

Hi kpenigar,

As far as we understood your problem you have two options to solve it:
1. Register the three needed assemblies in the GAC. They are: 'Microsoft.Office.Interop.Excel.dll', 'Microsoft.Vbe.Interop.dll' and 'Office.dll'.
2. Deploy the three assemblies in the same folder where your other extension assemblies reside. This is the way we do it here, so we kind of recommend it.

If you have any other questions do not hesitate to contact us.

Sincerely Yours
Support Team