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/10/01 13:12:00 UTC
[jira] [Commented] (XMLBEANS-571) Excel file read failure using
xmlbeans 3.0.0 whereas it works on xmlbeans 2.6.0
[ https://issues.apache.org/jira/browse/XMLBEANS-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17423279#comment-17423279 ]
Sateesh commented on XMLBEANS-571:
----------------------------------
we have multiple teams depending on POI and they need some time and plan to migrate to later versions is what I said. They cannot migrate immediately as and when a issue comes up is what I meant. Identified the current issue is fixed in EvilUnclosedBRFixingInputStream.java and the job runs successfully now. Waiting for customer's feedback
> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org