org.zkoss.poi.POIXMLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • reproducting steps: # load a empty xlsx file # insert a new sheet # export/save it # switch to this new sheet # input some text into any cell # export/save again #* this file can't load by ZSS and Excel error message on Excel: {noformat} Replaced Part: /xl/worksheets/sheet3.xml part with XML error. A text/xml declaration may occur only at the very beginning of input. Line 2, column 344. {noformat} stack trace on ZSS: {noformat} 2013-08-21 11:21:11.145:WARN::/ org.zkoss.poi.POIXMLException: org.apache.xmlbeans.XmlException: error: Unexpected element: XML_DOC_OR_TEXT_DECL at org.zkoss.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:199) at org.zkoss.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:189) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:355) at org.zkoss.poi.POIXMLDocument.load(POIXMLDocument.java:159) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:272) at org.zkoss.zss.model.sys.impl.XSSFBookImpl.<init>(XSSFBookImpl.java:101) at org.zkoss.zss.model.sys.impl.ExcelImporter.importsFromStream(ExcelImporter.java:107) at org.zkoss.zss.model.sys.impl.ExcelImporter.imports(ExcelImporter.java:73) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:51) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:71) at org.zkoss.zss.app.repository.impl.SimpleRepository.load(SimpleRepository.java:59) at org.zkoss.zss.app.ui.AppCtrl.doLoadBook(AppCtrl.java:308) at org.zkoss.zss.app.ui.AppCtrl.doAfterCompose(AppCtrl.java:182) at org.zkoss.zk.ui.impl.UiEngineImpl.doAfterCompose(UiEngineImpl.java:533) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:835) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.createComponents(UiEngineImpl.java:1035) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents0(AbstractExecution.java:246) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents(AbstractExecution.java:238) at org.zkoss.zul.Include.afterCompose(Include.java:450) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:833) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:397) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:327) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at org.mortbay.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:503) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}
    via by paowang,
  • reproducting steps: # load a empty xlsx file # insert a new sheet # export/save it # switch to this new sheet # input some text into any cell # export/save again #* this file can't load by ZSS and Excel error message on Excel: {noformat} Replaced Part: /xl/worksheets/sheet3.xml part with XML error. A text/xml declaration may occur only at the very beginning of input. Line 2, column 344. {noformat} stack trace on ZSS: {noformat} 2013-08-21 11:21:11.145:WARN::/ org.zkoss.poi.POIXMLException: org.apache.xmlbeans.XmlException: error: Unexpected element: XML_DOC_OR_TEXT_DECL at org.zkoss.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:199) at org.zkoss.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:189) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:355) at org.zkoss.poi.POIXMLDocument.load(POIXMLDocument.java:159) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:272) at org.zkoss.zss.model.sys.impl.XSSFBookImpl.<init>(XSSFBookImpl.java:101) at org.zkoss.zss.model.sys.impl.ExcelImporter.importsFromStream(ExcelImporter.java:107) at org.zkoss.zss.model.sys.impl.ExcelImporter.imports(ExcelImporter.java:73) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:51) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:71) at org.zkoss.zss.app.repository.impl.SimpleRepository.load(SimpleRepository.java:59) at org.zkoss.zss.app.ui.AppCtrl.doLoadBook(AppCtrl.java:308) at org.zkoss.zss.app.ui.AppCtrl.doAfterCompose(AppCtrl.java:182) at org.zkoss.zk.ui.impl.UiEngineImpl.doAfterCompose(UiEngineImpl.java:533) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:835) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.createComponents(UiEngineImpl.java:1035) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents0(AbstractExecution.java:246) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents(AbstractExecution.java:238) at org.zkoss.zul.Include.afterCompose(Include.java:450) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:833) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:397) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:327) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at org.mortbay.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:503) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}
    via by paowang,
    • org.zkoss.poi.POIXMLException: org.apache.xmlbeans.XmlException: error: Unexpected element: XML_DOC_OR_TEXT_DECL at org.zkoss.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:199) at org.zkoss.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:189) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:355) at org.zkoss.poi.POIXMLDocument.load(POIXMLDocument.java:159) at org.zkoss.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:272) at org.zkoss.zss.model.sys.impl.XSSFBookImpl.<init>(XSSFBookImpl.java:101) at org.zkoss.zss.model.sys.impl.ExcelImporter.importsFromStream(ExcelImporter.java:107) at org.zkoss.zss.model.sys.impl.ExcelImporter.imports(ExcelImporter.java:73) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:51) at org.zkoss.zss.api.impl.ImporterImpl.imports(ImporterImpl.java:71) at org.zkoss.zss.app.repository.impl.SimpleRepository.load(SimpleRepository.java:59) at org.zkoss.zss.app.ui.AppCtrl.doLoadBook(AppCtrl.java:308) at org.zkoss.zss.app.ui.AppCtrl.doAfterCompose(AppCtrl.java:182) at org.zkoss.zk.ui.impl.UiEngineImpl.doAfterCompose(UiEngineImpl.java:533) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:835) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.createComponents(UiEngineImpl.java:1035) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents0(AbstractExecution.java:246) at org.zkoss.zk.ui.impl.AbstractExecution.createComponents(AbstractExecution.java:238) at org.zkoss.zul.Include.afterCompose(Include.java:450) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:833) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:781) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:690) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:752) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:712) at org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:654) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:397) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:312) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:327) at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126) at org.mortbay.jetty.servlet.DefaultServlet.doGet(DefaultServlet.java:503) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
    No Bugmate found.