Adding a pie chart to an Excel worksheet using the Apache POI library?

Possible duplicate:
Create Excel spreadsheet using Apache POI

Can I add different tables to an Excel worksheet using the Apache POI library ?

+4
source share
1 answer

Not at present. They talk about XSSF support in the list of developers, from the contributor, but so far nothing. If you want monkeys with a lot of XML, then at present you can pretty much do something with XSSF, but it's complicated. You will need to find a list of developers.

The recommended solution is to create a template file with the diagrams you want in them. Tables must be defined using named ranges for all data in them. Now open this in the POI (either HSSF or XSSF) and put all your data. Finally, update the named range to indicate the data you added. When you open Excel, it will display your chart with the new data.

+2
source

All Articles