Question posted 2010 · +15 upvotes
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?
Accepted answer +5 upvotes
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.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.