2018a Apache POI incompatibility with the Text Analytics Toolbox

I use Apache POI to write xlsx files and avoid the excel COM server. 2018a breaks this if I install the Text Analytics Toolbox. While removing this tool box is a workaround, can someone suggest which future versions will fully support writing XLSX files independently of the excel COM, and if it'll remove the need for use of Apache?

Thanks

[Thomas Pfau]

Hi,

I'm in a similar position:

We are using POI to allow proper xlsx IO on unix systems, but beginning with 2017b the shipped Text analytics toolbox provides an, unfortunately incomplete or broken Apache POI in the tika-app.jar file.

It seems, that some dependency for this jars are not properly matched, as it is possible to load xls files and create HSSFWorkBooks but its impossible to create XSSFWorkbooks and thus read xlsx files.

This breaks a lot of things for Linux users and is pretty annoying. I tried to see, if there is any way to get the dependencies matched, but I couldn't find anything. Any help would be appreciated

[Thomas Pfau]

Another update:

I tried to see, if there is just some missing dependency, that can be added in order to have it work, and according to the jar file this version of tiki-app uses POI 3.15. So I added all requirements for poi 3.15 to the class path.

Now, if I remove the tika-app.jar file from the path, and add the poi library components, I can get an XSSF factory, but if the tika-app jar is on the java class path trying to create an XSSFWorkbook leads to a Class Not Found error.

[Jeff]

Hi Thomas, 2018b now includes a writetable switch to avoid MS COM, which is why I was using POI. While not as fully functional as POI, it has solved my issue with running background tasks, so I'll not be explicitly using POI in the future.

[Thomas Pfau]

Unfortunately that doesn't help if you use POI to have a proper xls IO on a UNIX System, which is our use case.