|Summary:||xlsx output by POI 4.0.0 cannot be opened because file format or extension is not valid.|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
|Attachments:||corrupted output xlsx by using 4.0.0|
Description Peng 2018-09-18 11:42:56 UTC
With previous version 3.17 there is no problem with created .xlsx output. After upgrade to 4.0.0 the output .xlsx is corrupted and can not be opened anymore with the message "...file format or file extension is not valid...". Used java version is same: jdk1.8.0_172. My program uses a predefined xlsx as template, at run time this template will be populated with data from database.
Comment 1 PJ Fanning 2018-09-18 11:59:21 UTC
Hi Peng - could you upload a corrupted xlsx file so that we can check its format?
Comment 2 Peng 2018-09-18 12:52:00 UTC
Created attachment 36153 [details] corrupted output xlsx by using 4.0.0
Comment 3 Peng 2018-09-18 13:00:00 UTC
(In reply to PJ Fanning from comment #1) > Hi Peng - could you upload a corrupted xlsx file so that we can check its > format? Hi Fanning, the file is available for download under the given link from dropbox. Thank you for your support.
Comment 4 Peng 2018-09-19 09:12:33 UTC
Comparing to version 3.17, jaxb-xxx.2.3.0 are now included in 4.0.0. Does this change may have to do with the mentioned issue?
Comment 5 PJ Fanning 2018-09-19 10:26:31 UTC
Jaxb build dependency is for Java 10 build. It is unlikely to be causing your issue. I no longer have M$ tools installed, so I'm not really in a position to debug what's up with your file. I can confirm that it doesn't load in LibreOffice, MacOS Numbers or Google Spreadsheets. I can't see anything obvious in the xlsx zip contents.