CODEWITHSUNDEEP
javaexcelchartsapache-poi
Jeff Storey
Jeff Storey

Reputation: 57192

Create Excel Charts in Java

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?

Upvotes: 15

Views: 11713

Answers (3)

Nathan
Nathan

Reputation: 2062

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.

Upvotes: 5

matt b
matt b

Reputation: 139931

I prefer using JExcel to POI (the API is simpler) but it seems like they don't support the 2007 formats yet either.

Upvotes: 0

Mariano Desanze
Mariano Desanze

Reputation: 8163

I have not used the Java edition of Aspose Cells but I've used the .NET edition and it is really nice. Over there it says that it can open and save XLSX. It's not free nor open source, though.

Upvotes: 1

Related Questions