Excel has unreadable content Error When creating excel using SXSSF API

2017-02-02 Thread rhyashu
I am getting "Excel has unreadable content Error" When creating excel using SXSSF API. Below are the jars that i am using: poi-3.9 poi-ooxml-3.9.jar poi-ooxml-schemas-3.9.jar xmlbeans-2.4.0.jar public class CarveOutReportXLSFileDownload extends AbstractXlsxStreamingView { protected void b

Re: Excel has unreadable content Error When creating excel using SXSSF API

2017-02-02 Thread rhyashu
I tried with POI 3.11 version but with that i am getting some other error. I researched and found that it has somthing to do with JRE 1.6. Our app is currently running on WAS 8.5 with JRE 1.6. Thats why it throw below error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()

Re: Excel has unreadable content Error When creating excel using SXSSF API

2017-02-02 Thread rhyashu
I was using poi-3.11, poi-ooxml-3.11 and xmlbeans-2.6 versions and i was able to run the reports fine in my local system but when i tried deploying that application in WAS8.5 with JRE 1.6 its started giving me that error. Please let me know what all jar i should be including and if there is any ver

Re: Excel has unreadable content Error When creating excel using SXSSF API

2017-02-02 Thread rhyashu
Thanks, Yes there are other dependencies as well mentioned below: dependencies { // spring dependencies compile("org.springframework.boot:spring-boot-configuration-processor") compile("org.springframework.boot:spring-boot-starter") compile("org.springframework.boot:s

Re: Excel has unreadable content Error When creating excel using SXSSF API

2017-02-03 Thread rhyashu
Hi These are all the dependencies that i shared earlier.If you want i can share the complete build.gradle file. I am not getting anything in the logs during build. Thanks for your help really appreciate it. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-has-unre

Re: Excel has unreadable content Error When creating excel using SXSSF API

2017-02-03 Thread rhyashu
I did try to replicate the scenario on a temp WAS system with JRE 1.7 and i was able to run the poi-3.11 version to generate XLSX using streaming API but after excel file was generated i was getting the "unreadble content found" error, screen shot attached. This is the same error that i was gettin