poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Cochran <r2cochr...@gmail.com>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Mon, 10 Jul 2017 17:16:13 GMT
Hi, does it make a difference that the Results2.xlsx file contains a
drawing1.xml? With the understanding that I myself am just learning how to
use the POI to generate Excel workbooks and sheet data.

Thanks

Bob Cochran
Greenbelt, Maryland


On Mon, Jul 10, 2017 at 12:33 PM, Carl Buxbaum <cbuxbaum@bamboorose.com>
wrote:

> Thank you.  I think the difference is that my local environment on Tomcat
> is using the Oracle JVM, while the environment where this is an issue is
> using the IBM JVM.  So the zip implementation must be different.
>
> I will go ahead an open up a bug ticket.
>
> Carl Buxbaum
> Senior Software Architect
> 17 Rogers Street
> Gloucester / Massachusetts / 01930 / USA
> 1-978-515-5128
>
> Bamboo Rose
> The only B2B marketplace powered by proven trade engines.
> www.BambooRose.com<http://www.bamboorose.com/>
>
> Join Bamboo Rose for STARS 2017, our user conference in Boston this
> October! Register Today!<https://www.eventbrite.
> com/e/stars-2017-bamboo-rose-user-conference-tickets-31684750943>
>
> Make Retail. Fun. Connected. Easier. Smarter. Together. Better.
>
>
> From: Andreas Beeker <kiwiwings@apache.org<mailto:kiwiwings@apache.org>>
> Reply-To: POI Users List <user@poi.apache.org<mailto:user@poi.apache.org>>
> Date: Monday, July 10, 2017 at 11:48 AM
> To: POI Users List <user@poi.apache.org<mailto:user@poi.apache.org>>
> Subject: Re: corruption in xlsx spreadsheet generated by poi?
>
>
> 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%
>
>
>
> ________________________________
>
> DISCLAIMER: E-mails and attachments from Bamboo Rose, LLC are
> confidential. If you are not the intended recipient, please notify the
> sender immediately by replying to the e-mail, and then delete it without
> making copies or using it in any way. No representation is made that this
> email or any attachments are free of viruses. Virus scanning is recommended
> and is the responsibility of the recipient.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message