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]]

"zhangyl" <zh*****@mail.nai.edu.cn> schrieb:

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>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[zhangyl]

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

"Herfried K. Wagner [MVP]" <hi***************@gmx.at>
??????:u$**************@TK2MSFTNGP11.phx.gbl...

"zhangyl" <zh*****@mail.nai.edu.cn> schrieb:

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>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Herfried K. Wagner [MVP]]

"zhangyl" <zh*****@mail.nai.edu.cn> schrieb:

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.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[zhangyl]

Thank you. I have tried it successfully.

"Herfried K. Wagner [MVP]" <hi***************@gmx.at>
??????:eG*************@TK2MSFTNGP09.phx.gbl...

"zhangyl" <zh*****@mail.nai.edu.cn> schrieb:

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.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>