-
FEATURED COMPONENTS
First time here? Check out the FAQ!
Hi guys. I'm exporting a spreadsheet to
ByteArrayOutputStream
Exporter c = Exporters.getExporter("excel"); ByteArrayOutputStream baos = new ByteArrayOutputStream(); c.export(spreadsheet.getBook(), baos); ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
It exports fine but if I add dynamic rows to spreadsheet such as
Ranges.range(spreadsheet.getSelectedSheet(), 10, 1).insert(Range.SHIFT_UP, Range.FORMAT_LEFTABOVE);
org.apache.xmlbeans.impl.values.XmlValueDisconnectedException >> at org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1213) >> at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getR(Unknown Source) >> at org.zkoss.poi.xssf.usermodel.XSSFRow.onDocumentWrite(XSSFRow.java:460) >> at org.zkoss.poi.xssf.usermodel.XSSFSheet.write(XSSFSheet.java:2725) >> at org.zkoss.poi.xssf.usermodel.XSSFSheet.commit(XSSFSheet.java:2694) >> at org.zkoss.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:313) >> at org.zkoss.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:317) >> at org.zkoss.poi.POIXMLDocument.write(POIXMLDocument.java:173) >> at org.zkoss.zss.model.impl.ExcelExporter.export(ExcelExporter.java:36) >> at com.pespa.ctrl.OfferItemsCtrl.onClick$btnPrint(OfferItemsCtrl.java:62) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:597) >> at org.zkoss.zk.ui.event.GenericEventListener.onEvent(GenericEventListener.java:82) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2741) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2712) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2653) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:308) >> at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:331) >> at org.zkoss.zk.ui.AbstractComponent$ForwardListener.onEvent(AbstractComponent.java:3179) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2741) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2712) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2653) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1699) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1484) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1201) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:558) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:456) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:464) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) >> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) >> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498) >> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) >> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) >> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562) >> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394) >> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243) >> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188) >> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166) >> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302) >> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:662)
What's wrong? I couldn't figure out for days! Help kindly appreciated.
Asked: 2012-04-29 10:55:09 +0800
Seen: 281 times
Last updated: Apr 30 '12