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: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
