What JAVA libraries do you use to work with excel files?

Question

Java

For quite a long time, all the required functionality was implemented using Apach POI. Recently, there has been a need to do some more complex things within Excel, and I ran into the problem of the lack of functionality in this library ... In particular: graphs are only very primitive, there are no data types for cells (well, that is, you can set something like masks, but Excel does not perceive this as a data type), for a too long merge operation (although this is questionable here, maybe just code optimization will save it). If anyone has any advice I would be very grateful. Naturally, I would like some kind of free serious library with documentation, but paid ones can also be considered if they are worth it.

Answer 1

There is JExcelApi, but for everything to be, you need to work directly with the Excel COM shell, it's difficult in Java, write in C #.

Answer 2

The choice is not so big, try docx4j, if it's completely edge then jni and Open XML SDK.

Answer 3

Try jXLS ( jxls.sourceforge.net/).
It is based on Apache POI, but you can create XLS templates, declare the behavior of filling the desired cells. Then you feed the data and the template into jXLS and you get what you need.

Answer 4

xelem - allows you to work with Excel documents in xml format