Home All Groups Group Topic Archive Search About

embem Excel in winford using vb.net

Author
23 Nov 2006 2:39 AM
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

Author
23 Nov 2006 4:20 AM
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


Show quoteHide quote
On Nov 23, 7:39 am, "Thomas" <chao.f***@gmail.com> wrote:
> 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
Author
23 Nov 2006 4:43 AM
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.

Kodali Ranganadh wrote:
Show quoteHide quote
> 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