Dear POI Team,
I have a web application which uses poi api to write to an Excel file. I am
processing a file created in Excel with 97-2003 compatibility. However, the
new version of this file creates the error trace given below.
I am using the POI-3.5 which I downloaded today and titled to be the
20090928 version.
I have seen that there is a previous thread on this. As suggested, I checked
for the application server (this is not my development environment) and no
other poi api jars can be found on the server. Therefore I am assuming that
this is not the problem.
Do you have any other suggestions? Is there a straightforward way to make
the file available to you?
Thank you.
Irem
org.apache.poi.hssf.record.RecordFormatException: Duplicate
PageSettingsBlock record (sid=0x89c)
at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.checkNotPresent(Page
SettingsBlock.java:227)
at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.readARecord(PageSett
ingsBlock.java:215)
at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.addLateRecords(PageS
ettingsBlock.java:639)
at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:222)
at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:158)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:286)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:200)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:182)
at list.CreateNew.writeQuotation(CreateNew.java:210)
at list.CreateNew.CreateQuotationDR(CreateNew.java:176)
at list.CreateNew.processRequest(CreateNew.java:84)
at list.CreateNew.doPost(CreateNew.java:139)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at
org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFi
lterChain.java:427)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:315)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext
Valve.java:287)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:218)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at
com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLock
ingStandardPipeline.java:98)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222
)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:166)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648
)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593
)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288)
at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(
DefaultProcessorTask.java:647)
at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(Defa
ultProcessorTask.java:579)
at
com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(Defaul
tProcessorTask.java:831)
at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTas
k(DefaultReadTask.java:341)
at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadT
ask.java:263)
at
com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadT
ask.java:214)
at
com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at
com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerTh
read.java:106)
