Create Excel Charts in Java

Question

I've been using Apache POI to create and modify Excel spreadsheets, but I'm wondering if there is a way (even if it's with a different library, preferably open source) to create charts in Excel in the new xlsx format. It looks like POI has an HSSFChart but I believe that's for the older format (please correct me if I'm wrong). Has anyone used a Java solution to create charts in Excel?

Answer 1

An option may be to create the charts beforehand and use POI to write the values where the chart can read them.

That is what I ended up doing, and it works great.

Make sure if you have formulas in your data, you go through every cell in the spreadsheet and evaluate them before writing it out to disk.