How to use POI in Matlab 2018a+

4 views (last 30 days)
Thomas Pfau
Thomas Pfau on 9 Oct 2018
Commented: Thomas Pfau on 12 Nov 2018
Hi,
The text analytics toolbox in Matlab 2018a ships a 3.15 version of apache POI (bundled as part of the tika-app.jar). Unfortunately, this version seems incomplete or at least it is impossible to create XSSFWorksheets with the version shipped with Matlab. The jar file indicates, that it is version 1.14 of the tika-app.jar, but it misses quite a bit of code compared with the tika-app.jar provided by the apache tika project.
We used to use POI to write xls/xlsx files on Linux systems due to the limitations of the xlswrite function (mainly using the great xlwrite FileExchange contribution). However, since Matlab now ships its own POI version, this is no longer possible, as any additional POI version added to the path will not be recognized, and the shipped version is used. Is there any way (besides uninstalling the text analytics toolbox, or removing the tika-app.jar from the path), to get a working POI library in the current matlab versions?
  1 Comment
Thomas Pfau
Thomas Pfau on 12 Nov 2018
Wouldn't this be a perfect example for the use of the newly announced Bugfix and Security Updates feature?
Possibly along with an update to older geo access code that tries to access a http service which is shut down in favor of an https service.

Sign in to comment.

Answers (0)

Categories

Find more on Environment and Settings in Help Center and File Exchange

Products


Release

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!