Using Excel Type Library 5.0 in C#

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henrik Hofmann - 16 Sep 2003 12:06 GMT

Hi all,

I'm trying to use the Excel 5.0 Type Library in C#

I've managed to create an Excel Instance using
Excel._ExcelApplicationClass xl = new Excel._ExcelApplicationClass();

But now I don't know how to go on, opening an template writing into it and
to print.

Most examples on the net don't use C# and can access the Application
Interface directly. I'm not able to cast _ExcelApplicationLClass() to
Application which would offer the methods to make Excel visible etc.

Thanks for your help

Reply to this Message

Paul Clement - 16 Sep 2003 16:07 GMT

¤ Hi all,
¤
¤ I'm trying to use the Excel 5.0 Type Library in C#
¤
¤ I've managed to create an Excel Instance using
¤ Excel._ExcelApplicationClass xl = new Excel._ExcelApplicationClass();
¤
¤
¤
¤ But now I don't know how to go on, opening an template writing into it and
¤ to print.
¤
¤
¤
¤ Most examples on the net don't use C# and can access the Application
¤ Interface directly. I'm not able to cast _ExcelApplicationLClass() to
¤ Application which would offer the methods to make Excel visible etc.

You may want to check the following MS KB articles:

http://makeashorterlink.com/?A2B843AE5

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Henrik Hofmann - 16 Sep 2003 17:17 GMT

Thanks for your help but all listed articles need excel 2002, I'm trying to
automate using excel97 so i can't use oxppia.

bye

> ¤ Hi all,
> ¤
[quoted text clipped - 20 lines]
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 16 Sep 2003 19:08 GMT

¤ Thanks for your help but all listed articles need excel 2002, I'm trying to
¤ automate using excel97 so i can't use oxppia.
¤

Not all of those references implement the PIA. For example, the following uses the standard interop
assembly:

http://support.microsoft.com/default.aspx?scid=kb;en-us;302084

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Henrik Hofmann - 16 Sep 2003 21:32 GMT

This may be due to a different version of the type library but i can't call
Excel.Application xl = new Excel.Application(); only
Excel._ExcelApplicationClass xl = new Excel._ExcelApplicationClass();

When i use the library Excel.Application is an interface and not a class so
i can't instatiate it. _ExcelApplicationClass can't be casted to Application
and doesn't offer the same methods as Application.

> ¤ Thanks for your help but all listed articles need excel 2002, I'm trying to
> ¤ automate using excel97 so i can't use oxppia.
[quoted text clipped - 7 lines]
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 18 Sep 2003 15:27 GMT

¤ This may be due to a different version of the type library but i can't call
¤ Excel.Application xl = new Excel.Application(); only
¤ Excel._ExcelApplicationClass xl = new Excel._ExcelApplicationClass();
¤
¤ When i use the library Excel.Application is an interface and not a class so
¤ i can't instatiate it. _ExcelApplicationClass can't be casted to Application
¤ and doesn't offer the same methods as Application.

Is there a reason why you're using the Excel 5.0 library? Excel 97 implements the version 8.0
library.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Using Excel Type Library 5.0 in C#

Free Magazines