You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "PJ Fanning (Jira)" <ji...@apache.org> on 2021/09/24 16:16: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=17419871#comment-17419871 ]
PJ Fanning commented on XMLBEANS-571:
-------------------------------------
The combination of POI 3.17 and XMLBeans 3.0.0 seems to work on test.xlsx. POI 3.17 is an easier upgrade for you - there are some code changes in POI 4 and 5 that might mean you need to rewrite some of your code - but it is strongly recommended to go to the latest versions for security patches and other bug fixes.
> 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