I need to create some java program behind the webserver which will read some values from the DB based on the input. i then need to open an excel application dynamically to create an excel chart using those values. Is there a way for this.
Is there any freeware tools which I can make use of ?
Well , I just asked my colleauge who had given presentation on POI. As told by him,You can't create excel chart through java. but if you already have chart template in an excel file then modifying the data in the range will be refelcted in the chart.
Hi Damanjit, Thanks for the info. Does this mean that I should have one template excel file(with chart template) for every report and update them with the data. Will this work over the web, ie, I have to put this logic somewhere on my servlet.
Has someone done this or is there any links to refer to.
Yes thats what I mean you need to create templates.
I don't know how to upload excel file with chart on web browser. However to upload the chart, may be first using POI you get access to chart range in excel file and then using jasper reports convert it to pdf file which can be then uploaded on web. Might be a bad idea but I don't know of other things.