Many Thanks Nick for the suggestions! I understand the situation now. I will look for the latter solution at the moment. Rahul
On Tue, Feb 8, 2011 at 3:52 PM, Nick Burch <[email protected]> wrote: > On Tue, 8 Feb 2011, rahul.soa wrote: > >> Charts creation from Apache POI is possible from scratch? >> > > HSSF has some limited support in scratchpad, but more work is needed. > Patches are very welcome! (You'll need to create some simple charts in > excel, use biffviewer to see the records, then do some more work on > HSSFChart and friends) > > I don't think XSSF has support yet, but here it should be much easier. We > already have the xsd derived classes to generate the contents, we just need > some usermodel code to pull it together. For this, you'd want to create some > simple charts in excel, unzip the .xlsx file and look at what XML gets > generated. Then, create usermodel code that calls the appropriate factory > methods, and manipulates the xmlbeans objects. Again, patches very much > appreciated! > > > What everyone tends to do in the mean time is create a template with a > chart in it driven from a named range, which is styled how they like. They > then add the data in with poi, update the named range, then excel updates > the chart when it opens and you see your data. > > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
