Hmm, for some reason my attached files did not make it into the thread. Is there a UI where I can attach them?
Thanks, Carl On 2017-07-10 11:11 (-0400), Carl Buxbaum <[email protected]> wrote: > 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" <[email protected]> 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 <[email protected]> > >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" <[email protected]> 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: [email protected] > >> >For additional commands, e-mail: [email protected] > >> > > >> >________________________________ > >> > > >> >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: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > >________________________________ > > > >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: [email protected] For additional commands, e-mail: [email protected]
