Excel automation

[Guest]

I'm automating Excel from asp.net application on window2000.
the application work fine on the developpement machine but not on the
production server.

when the runtime hit the second line of code:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook = xl.Workbooks.Open("file.xls")
it throw this error:
"System.InvalidCastException: QueryInterface for interface
Excel._Application failed"

thanks for help

 

[Stephen Bullen]

Hi Zino,

I'm automating Excel from asp.net application on window2000.
the application work fine on the developpement machine but not on the
production server.

when the runtime hit the second line of code:
Dim xl As New Excel.Application
Dim wb As Excel.Workbook = xl.Workbooks.Open("file.xls")
it throw this error:
"System.InvalidCastException: QueryInterface for interface
Excel._Application failed"

Excel is not designed to be run on a server in this manner. If you
search the Microsoft KB for 'Excel Server' you should find some
information about the (many) issues.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk