What is the best Java API to generate excel sheets (compatible with lateset Excel) including formulas? Is there more than POI and JXL?
3 Answers
I have been switching between POI and JXL a few times. Both work just fine. The reason I moved away from POI in the past was because the POI development went idled. That said, I have switched back to POI now that the development is active again. One thing I like about POI is it handles XLSX format too.
Comments
There is also this: http://jexcelapi.sourceforge.net/ , but POI is pretty much the standard.
Comments
Apache POI I have used in one of the projects. It worked well for me.
Supports many MS Office formats.