poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Buxbaum <cbuxb...@bamboorose.com>
Subject Re: corruption in xlsx spreadsheet generated by poi?
Date Mon, 10 Jul 2017 15:11:52 GMT
Hi, Here attached are the struts action and the helper class.  In my own
environment, where it works properly, I am using tomcat with jdk1.8.0_60
on a Mac.  In one of the environments where it creates the corrupted
excel, we are on WebSphere on Windows, running java 1.8.

More information about the circumstances.  It is different than what I had
mentioned earlier.  I had assumed that the difference in the files with
the linefeeds was the cause but it does not seem that it is:

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.

Thanks!

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-ticket
s-31684750943>

Make Retail. Fun. Connected. Easier. Smarter. Together. Better.






On 7/6/17, 4:34 PM, "Dominik Stadler" <dominik.stadler@gmx.at> wrote:

>Hi,
>
>Hm, sounds strange, in POI, the XML is created rather deep down in the
>library itself and should not be affected by Windows/Linux newlines. Can
>you share some code how exactly you create the file? Just to see you don't
>do anything unusual.
>
>Also which exact version of Java are you using here? i.e. output of java
>-version?
>
>Thanks... Dominik.
>
>On Thu, Jul 6, 2017 at 9:08 PM, Carl Buxbaum <cbuxbaum@bamboorose.com>
>wrote:
>
>> Thank you.  I had not realized that it was a zip file.  I was able to
>> generate another, non corrupt version from a different platform,
>> presumably with the same code.  The difference is that the corrupt
>>version
>> has the DOS CTRL-M ^M cr lf after a number of lines, especially the xml
>> header.  What in the environment of poi would cause that OS default
>>return
>> character to be inserted?
>>
>> Thanks,
>>
>> 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-ticket
>> s-31684750943>
>>
>> Make Retail. Fun. Connected. Easier. Smarter. Together. Better.
>>
>>
>>
>>
>>
>> On 7/6/17, 1:55 PM, "pj.fanning" <fanningpj@yahoo.com> wrote:
>>
>> >The xlsx file is a zip with XML files in it. I unzipped up your xlsx
>>but
>> >didn't see anything obvious.
>> >Maybe, you would be able to have a look yourself.
>> >The .rels XML link to other XML files and maybe it's worth checking to
>>see
>> >if there are relationships that are not valid (pointing to missing
>>files,
>> >etc).
>> >
>> >
>> >
>> >--
>> >View this message in context:
>> >http://apache-poi.1045710.n5.nabble.com/corruption-in-xlsx-
>> spreadsheet-gen
>> >erated-by-poi-tp5728053p5728055.html
>> >Sent from the POI - User mailing list archive at Nabble.com.
>> >
>> >---------------------------------------------------------------------
>> >To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> >For additional commands, e-mail: user-help@poi.apache.org
>> >
>> >________________________________
>> >
>> >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.
>>
>>
>> >
>>
>> ________________________________
>>
>> 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.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>________________________________
>
>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.

________________________________

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
View raw message