How to download "Excel 9.0 Object Library"?

Hi,< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

I created a small C# Windows app to read from an Excel file a couple of months back as an R&D for our new project in C#.
 

In that I used Excel 9.0 Object Library.

 

The problem is that now we and our customers have upgraded to Office 2003 and now the 9.0 is being replaced by Excel 11.0 Object Library.  I just started the actual development and to my shock found out that my original R&D form won’t compile.

 

One reason is that ExcelObj.Workbooks.Open takes 15 arguments instead of the earlier 13.

 

Also the System.Array myValues = (System.Array)range.Cells.value; statement fails because there is no value property in 11.0.  There is value2 property.  When you use that (i.e. value2) the (System.Array) cast gives an ‘invalid cast’ exception at runtime.

 

Can u please help me Is it possible to download Excel 9.0 Object Library and install it over the present 11.0   I tried searching for it with Google but was not successful.

 

We are on a very tight schedule and need urgent solution to this.  This Excel sheet loading program is the most important in the system.

 

 

Thanks & with best regards,

MCFS



Answer this question

How to download "Excel 9.0 Object Library"?

  • bcc_net

    You can try and use Excel 9.0 interops assemblies on Excel 11.0, but it most probably would not work. It might appeat to work, but you will hit edge cases from time to time and debugging those is a lot of pain.
    Best and only supported approach is to recompile your code

  • danhart26

    Hi,

    Thanks for your reply.

    I think u r right. 

    We finally managed to convice the customers to use Excel 2000.

    So prob solved.

    thanks

    mcfs


  • How to download "Excel 9.0 Object Library"?