Excel Advanced Error

0
in such cases which jar i need to remove because in my application we use both widget excel importer and advance excel i am getting below error An unhandled error occurred in the MxRuntime. -------- java.lang.NoSuchMethodError: org.apache.poi.util.XMLHelper.newDocumentBuilder()Ljavax/xml/parsers/DocumentBuilder;     at org.apache.poi.ooxml.util.DocumentHelper.newDocumentBuilder(DocumentHelper.java:47)     at org.apache.poi.ooxml.util.DocumentHelper.<clinit>(DocumentHelper.java:36)     at org.apache.poi.openxml4j.opc.internal.ContentTypeManager.save(ContentTypeManager.java:431)     at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:520)     at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1505)     at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:242)     at advanced_excel.actions.Workbook_Create.executeAction(Workbook_Create.java:58)     at advanced_excel.actions.Workbook_Create.executeAction(Workbook_Create.java:29)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)     at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152)     at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:30)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:56)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32)     at scala.Option.flatMap(Option.scala:283)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:172)     at scala.Option.flatMap(Option.scala:283)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:172)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:119)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54)     at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:26)     at
asked
4 answers
0

Hello,

Try to remove all the older versions of poi-ooxml libraries from the userlib folder.

 

Hope it helps!

answered
0

Hi, 


The latest versions of Excel importer/Excel exporter use POI 5.2.2.

Please delete all the jars related to POI, clean the deployment directory and download latest versions of Excel Exporter/Importer and Advanced Excel that are supported by your Mendix version.
 

answered
0

facing same issue. Have kept only PO 5.2.2 

still issue not resolved. 

can you tell how this issue was resolved ?

answered
0

Have you tried updating the version of both the modules,

I am using Excel exporter and Advanced excel along with JXLser modules, 

Excel importer and Advanced excel both are using POI 5.2.2 and it is not causing any issues 

answered