C# Excel 2000 and Excel 2003

DanRoche · December 11th, 2008, 01:27 PM

Hello all, hopefully you can help.

I have a C# app that creates Excel reports. I have Excel 2000 on my pc and have a reference to Microsoft Excel 9.0 object library.

This works for other users with pc's having Excel 2000 installed.

Now I have a set of users with Excel 2003 and my application gets an activex error cannot create object. I can't install Excel 2003 on my pc to get the Primary Interop Assembly.

Code:

Excel.Application objExcel = new Excel.Application();  //Error users with 2003

How can I have my application work for users of both Excel versions?

Thanks

DanRoche · December 12th, 2008, 11:23 AM

Well it looks like I have to use late binding to get around the version issue.

I was able to get it working using late binding, but only after I installed the office 2003 pia's on the user's machine.

cikaPero · March 4th, 2010, 05:10 AM

Hi,

there is a more simpler solution, forget about Excel Automation, and start using some real Excel C# component.

Forget about versioning issues, performance and security problems, especially in Excel ASP.NET apps.