Caused by: org.apache.xmlbeans.XmlException: error: 尾随节中不允许有内容

{_CACHEOBJTIME={RESBUNDLE.CNDERPDB=1693228883000, UCODE.CNDERPDB=1693276701882, SYSOPTS.CNDERPDB=1693273954026, RELEASE-TIME=1693228883000}}
org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
	at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:62)
	at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:403)
	at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:408)
	at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:155)
	at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:186)
	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:73)
	at snsoft.ms.poi.XlsUtil.newWorkbook(XlsUtil.java:64)
	at snsoft.ms.poi.XlsUtil.getSheetNames(XlsUtil.java:129)
	at snsoft.tools.data.XlsDataImportTblListener.updateTableNameList(XlsDataImportTblListener.java:297)
	at snsoft.tools.data.XlsDataImportTblListener.textValueChanged(XlsDataImportTblListener.java:256)
	at snsoft.awt.DialogPane.fireTextValueChanged(DialogPane.java:1253)
	at snsoft.awt.DialogPane.textValueChanged(DialogPane.java:1242)
	at snsoft.awt.util.QueryParamPane.textValueChanged(QueryParamPane.java:2893)
	at snsoft.awt.TextEditor.fireTextValueChanged(TextEditor.java:486)
	at snsoft.awt.TextEditor.setText(TextEditor.java:455)
	at snsoft.awt.TextEditor.setText(TextEditor.java:415)
	at snsoft.awt.TextFieldA.setValue(TextFieldA.java:291)
	at snsoft.awt.TextFieldA.actionPerformed(TextFieldA.java:507)
	at snsoft.awt.TextFieldA.mouseReleased(TextFieldA.java:1109)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at snsoft.awt.TextFieldA.processMouseEvent(TextFieldA.java:1344)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.WaitDispatchSupport$2.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(Unknown Source)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at snsoft.awt.DialogPane.showDialog(DialogPane.java:677)
	at snsoft.abas.bas.awt.AppAidDialogPane.showDialog(AppAidDialogPane.java:1682)
	at snsoft.abas.util.cli.AppUtil.openExcelImportUI(AppUtil.java:258)
	at snsoft.logistics.trade.cli.LogImportLiquidationBasCliListener.excelImportNew(LogImportLiquidationBasCliListener.java:73)
	at snsoft.logistics.trade.cli.LogImportLiquidationBasCliListener.tableActionPerformed(LogImportLiquidationBasCliListener.java:59)
	at snsoft.table.Table.fireActionPerformed(Table.java:8031)
	at snsoft.table.Table.perform(Table.java:7741)
	at snsoft.table.Table.actionPerformed(Table.java:7269)
	at snsoft.awt.IconButton.processActionEvent(IconButton.java:280)
	at snsoft.awt.IconButton$Button.setMousePressed(IconButton.java:464)
	at snsoft.awt.wt.SelfDrawButton.mouseReleased(SelfDrawButton.java:375)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:60)
	... 90 more
Caused by: org.apache.xmlbeans.XmlException: error: 尾随节中不允许有内容。
	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:688)
	at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:107)
	at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.<init>(XSSFVMLDrawing.java:102)
	... 95 more
Caused by: org.xml.sax.SAXParseException; systemId: file://; lineNumber: 418; columnNumber: 19; 尾随节中不允许有内容。
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$TrailingMiscDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
	at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3413)
	... 101 more

背景：

导入excel的时候，突然出现这个问题

处理方法：

1、换更高基本的POI版本

2、删除excel里面的批注，打开excel文件，点击【审阅】-【删除】，删除所有的批注，PS：导入模板一定要简洁，不要有什么花里胡哨的内容和格式，不然很容易出问题