embed Excel object in Winform using .Net

[Thomas]

It sounds a piece of cake but It is surprisingly frustrating to do. I
have a winform which receives data from database and present them as
Excel chart and spreadsheet. It is required by the client. I
can use Office Web Control to generate chart. However the chart can
only be export to a gif image, not Excel chart. bummer. I also tried
WebBrowser Control, but it can only open an Excel file from web or hard
drive. I cannot figure out how to create an Excel object and pass it to
the WebBrowser object. I dont want to use DsoFramer because MS doesnt
support it, plus it suffers the same shortcoming of WebBrowser.

What I need to do is to create an in-memory Excel object, populate it
with data and embed it in the winform, for the client wants to save a
copy of the file and do some further processing. Too bad the ole
container in VB is gone. Can someone suggest some main stream solution
to this problem. I am not very savvy at windows programming.

Thanx

[Michael Nemtsev]

Hello Thomas,

See there http://www.dotnet247.com/247referenc...55/277921.aspx

TIt sounds a piece of cake but It is surprisingly frustrating to do. I
Thave a winform which receives data from database and present them as
TExcel chart and spreadsheet. It is required by the client. I
Tcan use Office Web Control to generate chart. However the chart can
Tonly be export to a gif image, not Excel chart. bummer. I also tried
TWebBrowser Control, but it can only open an Excel file from web or
Thard
Tdrive. I cannot figure out how to create an Excel object and pass it
Tto
Tthe WebBrowser object. I dont want to use DsoFramer because MS doesnt
Tsupport it, plus it suffers the same shortcoming of WebBrowser.
TWhat I need to do is to create an in-memory Excel object, populate it
Twith data and embed it in the winform, for the client wants to save a
Tcopy of the file and do some further processing. Too bad the ole
Tcontainer in VB is gone. Can someone suggest some main stream
Tsolution to this problem. I am not very savvy at windows programming.
T>
TThanx
T>
---
WBR,
Michael Nemtsev [C# MVP] :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Thomas]

Michael,

I just out of my Thanksgiving dinner and see your post. I took a quick
look and it is very promising. Thanks alot.

Michael Nemtsev wrote:

Hello Thomas,

See there http://www.dotnet247.com/247referenc...55/277921.aspx