How to embed the excel worksheet into my forms?

[zhangyl]

I want to embed the excel worksheet into my application and use it like
datagrid, if somebody can tell a solution, whether visual studio 2005 can do
it ?
thanks.

 

[Herfried K. Wagner [MVP]]

I want to embed the excel worksheet into my application and use it like
datagrid, if somebody can tell a solution, whether visual studio 2005 can
do it ?

Unfortunately .NET 2.0 still does not support an OLE container control.

HOWTO: Use the WebBrowser Control to Open an Office Document in Visual Basic
..NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;304643>

 

[zhangyl]

thank you.
But how can I handle events of the excel application in the webbrowser
control?

 

[Herfried K. Wagner [MVP]]

But how can I handle events of the excel application in the webbrowser
control?

I don't think this is supported by this approach. You could try to use
'GetObject' to get a reference to the Excel instance running inside IE, but
I have never tried that.

 

[zhangyl]

Thank you. I have tried it successfully.

I don't think this is supported by this approach. You could try to use
'GetObject' to get a reference to the Excel instance running inside IE,
but I have never tried that.