poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Beeker <kiwiwi...@apache.org>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Mon, 10 Jul 2017 15:48:34 GMT
> If I create a ┬│corrupt┬▓ excel, unzip it, and then zip it back up (on my
> mac using zip command), the resulting zip file opens without issue.  If a
> colleague on Windows generates the same excel, and does the same  probably
> using windup, the corruption remains.

Please check if you see a difference with zipinfo:
http://www.info-zip.org/mans/zipinfo.html

See below [1] - for your "Results (2).xlsx".

I think there was something with the compression method,
i.e. not all compression methods might be supported -
also defN = "deflate normal" sound like a default compression.
IIRC there's also a file in our test-corpus with some strange compression method,
which poi can't open. 

> Hmm, for some reason my attached files did not make it into the thread.  Is there a UI
where I can attach them? 
Just open a ticket in the bugzilla:
https://bz.apache.org/bugzilla/enter_bug.cgi?product=POI&component=XSSF


Andi


[1]

$ zipinfo Results2.xlsx 
Archive:  Results2.xlsx
Zip file size: 6744 bytes, number of entries: 11
-rw----     2.0 fat      596 bl defN 17-Jul-06 10:02 _rels/.rels
-rw----     2.0 fat     1195 bl defN 17-Jul-06 10:02 [Content_Types].xml
-rw----     2.0 fat      184 bl defN 17-Jul-06 10:02 docProps/app.xml
-rw----     2.0 fat      441 bl defN 17-Jul-06 10:02 docProps/core.xml
-rw----     2.0 fat      131 bl defN 17-Jul-06 10:02 xl/drawings/drawing1.xml
-rw----     2.0 fat      138 bl defN 17-Jul-06 10:02 xl/sharedStrings.xml
-rw----     2.0 fat     3601 bl defN 17-Jul-06 10:02 xl/styles.xml
-rw----     2.0 fat      350 bl defN 17-Jul-06 10:02 xl/workbook.xml
-rw----     2.0 fat      574 bl defN 17-Jul-06 10:02 xl/_rels/workbook.xml.rels
-rw----     2.0 fat    22610 bl defN 17-Jul-06 10:02 xl/worksheets/sheet1.xml
-rw----     2.0 fat      303 bl defN 17-Jul-06 10:02 xl/worksheets/_rels/sheet1.xml.rels
11 files, 30123 bytes uncompressed, 5226 bytes compressed:  82.7%


Mime
View raw message