Re: Excel cell with note failing on xmlbeans 3.0.0

Poi 3.1.14 is very old and is not compatible with XMLBeans 3 or greater.

You must update Poi and XMLBeans together.

Sent from my iPhone

> On Sep 24, 2021, at 8:37 AM, Sateesh K Kolusu <[email protected]> wrote:
> 
> Hello Fanning - Here is the java program & excel file for reproduction.
> 
> With xmlbeans 3.0.0 the program fails with similar exception while it outputs excel values with xmlbeans 2.6.0.
> 
> 
> 
> 
> Steps to reproduce
> 1) export CLASSPATH pointing to the following jars ( could not attach due to size restrictions)
> poi-3.14.jar
> poi-ooxml-3.14.jar
> poi-ooxml-schemas-3.14.jar
> xmlbeans-3.0.0.jar
> 2) compile the java program
> 3) run the java class
> You will find similar exception whereas when  xmlbeans2.6.0 is used it outputs successfully. 
> 
> A bug XMLBEANS-571is already raised.
> 
> ---
> Thanks
> Sateesh 
> 
> 
> 
> From:        "PJ Fanning" <[email protected]>
> To:        "POI Users List" <[email protected]>
> Date:        23-09-2021 18:42
> Subject:        [EXTERNAL] Re: Excel cell with note failing on xmlbeans 3.0.0
> 
> 
> 
> I'm afraid that we can't help if you don't supply a xlsx file or reproduction steps. Use stackoverflow if you want to go this route.
> 
> Could you start by unzipping the xlsx file and checking the xml files inside it?
> 
> The exception you are getting - org.xml.sax.SAXParseException: Content is not allowed in
> trailing section.
> 
> This is usually caused by someone leaving random text in the XML after the final end tag.
> 
> 
> 
> 
> On Thursday 23 September 2021, 13:59:04 IST, Sateesh K Kolusu <[email protected]> wrote: 
> 
> 
> 
> 
> 
> Thank you Fanning. But how did adding a excel feature ie., note to a cell 
> made the file invalid ?  I am not adding anything that is outside Excel 
> features. How did it affect the xml file internally?
> 
> ---
> Thanks
> Sateesh 
> 
> 
> 
> From:  "PJ Fanning" <[email protected]>
> To:    "POI Users List" <[email protected]>
> Date:  23-09-2021 16:21
> Subject:        [EXTERNAL] Re: Excel cell with note failing on xmlbeans 
> 3.0.0
> 
> 
> 
> 
> Hi Sateesh,
> POI is built and tested with specific XMLBeans releases. XMLBeans 3.0.0 is 
> a major upgrade and is not meant to be compatible with XMLBeans 2.6.0. The 
> versioning scheme is based on 
> https://semver.org/ 
> 
> You should be able to use newer XMLBeans 2.x.y versions.
> 
> XMLBeans 3.0.0 doesn't have many changes (from 2.6.0). See 
> https://xmlbeans.apache.org/history.html 
> 
> 
> I think you are affected by the removal of support for the Piccolo parser 
> - I'm assuming that it was more tolerant of invalid XML in the xlsx file 
> (xlsx files are just zip files).
> 
> Xerces parser is what you have in your stack trace.
> 
> It might be a good idea generally to upgrade POI - POI 3.14 is very old.
> 
> 
> 
> 
> 
> 
> On Thursday 23 September 2021, 11:40:30 IST, Sateesh K Kolusu 
> <[email protected]> wrote: 
> 
> 
> 
> 
> 
> Hi - I have an Excel file cell with note processing successfully with 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.
> 
> 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
> 
> ---
> Thanks
> Sateesh
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]