[
https://issues.apache.org/jira/browse/XMLBEANS-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419908#comment-17419908
]
Sateesh commented on XMLBEANS-571:
----------------------------------
Thank you but it is mentioned that any XMLBEANS version above 3.0.0. can be
used with POI.
_The ooxml schemas jars are compiled with [Apache
XMLBeans|https://xmlbeans.apache.org/] 2.3, and so can be used at runtime with
any version of XMLBeans from 3.0.0 or newer. Wherever possible though, we
recommend that you use XMLBeans 3.1.0 with Apache POI, and that is the version
now shipped in the binary release packages._
> Excel file read failure using xmlbeans 3.0.0 whereas it works on xmlbeans
> 2.6.0
> -------------------------------------------------------------------------------
>
> Key: XMLBEANS-571
> URL: https://issues.apache.org/jira/browse/XMLBEANS-571
> Project: XMLBeans
> Issue Type: Bug
> Affects Versions: Version 3.0.0
> Environment: linux
> Reporter: Sateesh
> Priority: Blocker
> Fix For: Version 3.0.0
>
> Attachments: XLSXReaderExample.java, test.xlsx
>
>
> I have an Excel file cell with note processing successfully with Apache POI
> 3.14 + xmlbeans 2.6.0.
> But when we moved to xmlbeans 3.0.0 it fails with following exception. If
> I delete the note in the Excel file it processes successfully with 3.0.0.
> Attached the testcase
> Source_File,0: org.apache.poi.POIXMLException:
> java.lang.reflect.InvocationTargetException
> at
> org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:65)
> at
> org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:601)
> at
> org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:613)
> at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:174)
> at
> org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:249)
> .......
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
> at
> org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
> at
> org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:62)
> ... 12 more
> Caused by: org.apache.xmlbeans.XmlException: error: Content is not allowed
> in trailing section.
> at
> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
> at
> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1271)
> at
> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1258)
> at
> org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
> at org.apache.xmlbeans.XmlObject$Factory.parse(XmlObject.java:747)
> at
> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:128)
> at
> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.<init>(XSSFVMLDrawing.java:116)
> ... 18 more
> Caused by: org.xml.sax.SAXParseException: Content is not allowed in
> trailing section.
> at
> org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
> Source)
> at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown
> Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
> Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
> Source)
> at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown
> Source)
> at
> org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown
>
> Source)
> at
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
> Source)
> at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown
> Source)
> at
> org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
> at
> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3413)
> ... 24 more
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
