|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
embem Excel in winford using vb.netIt 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 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 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
get values from asp pass to batch file !!!
A Modest Question Is VB.NET Stable?? Odd databinding behavior Need to create link between DataSet tables to show matching records Inherited handler problem. Restart a Sub and keep loop going SQL connection problem Simple Data UPdae Question Adapter Update...Syntax error |
|||||||||||||||||||||||