What are you using JAVA libraries for working with excel files?

Quite a long time, all of the required functionality was implemented using Apache POI. Recently there was a need to do some more complicated things within Excel and are faced with the problem of the lack of this library functionality... In particular: very primitive graphics only, no data types for cells (well i.e. you can specify something like a mask, but Excel does not see it as data type), for too long the merge operation (although that's in question here is probably just code optimization will save). If anyone has advice I would be grateful primnogo. I would like of course some serious free library with documentation, but paid can also be counted if they are worth it.
July 4th 19 at 23:49
4 answers
July 4th 19 at 23:51
JExcelApi is, but that was all, it is necessary to work directly with the COM Excel wrapper, in Java it is difficult to write in C#.
July 4th 19 at 23:53
The choice is not so big, try docx4j, if very edge of the jni and Open XML SDK.
July 4th 19 at 23:55
Try jXLS (jxls.sourceforge.net/).

It is built on the Apache POI, but you can create XLS templates to declare the behavior of the fill desired cells. Then feed the data and template in jXLS and get what you need.
July 4th 19 at 23:57
xelem - allows you to work with Excel documents in xml format

Find more questions by tags ExcelJava