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

I am new to windows desktop development in vb.net(basically a web application developer in C#), i think DGV Extension component will not work with my current "office excel 97". i am using vs2005 vb.net windows application enviroment with ms access 97 database.

Please somebody clarify the office version required?.

i am getting following error, just want to know whether higher version of office is needed or else there is problem somewhere else..

"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 located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)"

 

 

Hi udaykumarlazurus,

Thank you for your feedback

DataGridView Extension can export to MS Excel XP and later versions. This means that office 97 is not supported.

This and other answers can be found in our FAQ section.

Sincerely Yours
Support Team