embem Excel in winford using vb.net

[Thomas]

It sounds a piece of cake but I was suprised how frustrating it is to
do it. 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. 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

 

[Kodali Ranganadh]

Hi,
Y u are using the Excel chat controls, hear a lot of other 3rd party
controls provide a best and formost solutions..
Try this link ..
http://www.codeproject.com/showcase/Dundas_chartareas.asp

 

[Thomas]

Thanks. But my client want to be able to save the data and chart into
an Excel file and do some further processing on themselves. Not just to
see a pretty chart. I doubt Dundus can export the chart to Excel
though.