Hi Nick, Sorry, if it was already asked on the list. I'm just new to apache POI and also new for manipulation on excel sheet.
My objective is to build a GUI tool, which has got several fields and two buttons on the bottom, one is "Insert" and another one is "Launch". With the insert button I insert those field values in the excel sheet, and I want when I click Launch button, charts should be created from scratch in the excel sheet in the workbook. Charts creation from Apache POI is possible from scratch? If it is really not possible with the latest version of POI, the way you suggested, is there a sample example? somewhere in the user guide? Perhaps somebody from user list has already encountered the similar situation and can purpose the example. Many Thanks in advance, Rahul On Mon, Feb 7, 2011 at 9:29 PM, Nick Burch <[email protected]> wrote: > On Mon, 7 Feb 2011, rahul.soa wrote: > >> Now, I am intended to create some charts like pie, bar, pareto etc out of >> the data from excel sheet and place those charts in the same workbook in >> different sheets. Is this possible to do so with Apache POI? >> > > As mentioned several times in the list archives, the safest bet is to > create a template in excel with a named range, then use that in your chart. > You then use POI to populate all your data and update the named range, then > excel sees the new data in the chart > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
