You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Sateesh (Jira)" <ji...@apache.org> on 2021/09/24 15:31:00 UTC

[jira] [Created] (XMLBEANS-571) Excel file read failure using xmlbeans 3.0.0 whereas it works on xmlbeans 2.6.0

Sateesh created XMLBEANS-571:
--------------------------------

             Summary: 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
             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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org