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 <sateesh.kol...@in.ibm.com> > 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" <fannin...@yahoo.com.INVALID> > To: "POI Users List" <user@poi.apache.org> > 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 > <sateesh.kol...@in.ibm.com> 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" <fannin...@yahoo.com.INVALID> > To: "POI Users List" <user@poi.apache.org> > 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 > <sateesh.kol...@in.ibm.com> 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: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org
