Pentaho

 View Only

 MS Excel Writer doesn't work

Jump to Best Answer
Andrea Leto's profile image
Andrea Leto posted 09-23-2022 03:35

Good morning,
I am having problems with the "Microsoft Excel Writer" object, I need to create and write a .xlsx file but I cannot do it in any way.
Whereas if I use "Microsoft Excel Output" I can generate and write an .xls file.

I am using CE 9.2, my version of Apache POI is 4.11

How can I solve this?

I get this error:

2022-09-23 08:55:23,224 ERROR [org.pentaho.di] 2022/09/23 08:55:23 - Microsoft Excel writer.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Error opening new file
2022-09-23 08:55:23,225 ERROR [org.pentaho.di] 2022/09/23 08:55:23 - Microsoft Excel writer.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : java.lang.IllegalArgumentException: InputStream of class class org.apache.commons.compress.archivers.zip.ZipArchiveInputStream is not implementing InputStreamStatistics.
2022/09/23 08:55:23 - Microsoft Excel writer.0 - at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.<init>(ZipArchiveThresholdInputStream.java:65)


Thank you!

Mika Stykki's profile image
Mika Stykki Best Answer

This seems to be same problem than in ticket  -> https://jira.pentaho.com/browse/BISERVER-14811

1: Please find the pdm-ce-3.8.0.1.jar in the following location:

  • "tomcat/webapps/pentaho/WEB-INF/lib

2: Please move this file to another location (outside of the Pentaho directory).

3: Please restart your Pentaho Server and Test.

Luciano Donazzolo's profile image
Luciano Donazzolo
I don't know about CE 9.2
But I have no problems with "Microsoft Excel writer" step in CE 9.3.
May be you have to properly adjust options "Extension" and/or "If file output exists" and/or "If sheet exists in output file" in File&Sheet tab.

Luciano
Andrea Leto's profile image
Andrea Leto
Thx @Mika Stykki !!​