By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,582 Members | 1,720 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,582 IT Pros & Developers. It's quick & easy.

How to embed the excel worksheet into my forms?

P: n/a
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.
Feb 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"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/>

Feb 8 '06 #2

P: n/a
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/>

Feb 9 '06 #3

P: n/a
"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/>

Feb 9 '06 #4

P: n/a
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/>

Feb 10 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.