apache poi SXSSFWorkbook - java.lang.AbstractMethodError: apache poi

Question

我想做excel到文件使用apache poi SXSSFWorkbook类。

我在工作簿界面中使用的方法是void write(OutputStream stream) throws IOException。

但是发生了一个错误。错误消息是

java.lang.AbstractMethodError: org.apache.xerces.dom.DocumentImpl.getXmlStandalone()Z
        at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.setDocumentInfo(DOM2TO.java:377)
        at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:131)
        at com.sun.org.apache.xalan.internal.xsltc.trax.DOM2TO.parse(DOM2TO.java:98)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transformIdentity(TransformerImpl.java:684)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:728)
        at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:343)
        at org.apache.poi.openxml4j.opc.StreamHelper.saveXmlInStream(StreamHelper.java:80)
        at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:174)
        at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:466)
        at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1441)
        at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
        at org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:883)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
        at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:43)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
        at H0000000000000971615427686681096.writeFile(H0000000000000971615427686681096.groovy:223)
        at H0000000000000971615427686681096$writeFile.callCurrent(Unknown Source)
        at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:47)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:143)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:151)
        at H0000000000000971615427686681096.run(H0000000000000971615427686681096.groovy:108)
        at groovy.util.GroovyScriptEngine.run(GroovyScriptEngine.java:402)

我使用的xercesImpl-2.4.0.jar版本没有DocumentImpl.getXmlStandalone()方法。

而且我不能升级xercesImpl版本(因为有副作用)。

如何使用xercesImpl-2.4.0.jar编写excel文件？

poi版本类似于poi-3.12.jar

poi-ooxml-3.12.jar

poi-ooxml-schemas-3.12.jar

Answer 1

我通过更改工作簿实现解决了问题

SXSSFWorkbook -> HSSFWorkbook