0

Getting this issue in excel import. Excel Importer could not import any rows. Please check if the template is configured correctly. If the file was not created with Microsoft Excel for desktop, try opening the file with Excel and saving it with the same name before importing.   Steps of fixation tried till now Mendix version upgraded to 10.24.0 All app store module upgraded. Tried some jar cleaning also. Extension changes and new file creation also tried. but neither could help to resolve this issue.   java.lang.NoSuchFieldError: Class org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotCacheDefinition does not have member field 'org.apache.xmlbeans.impl.schema.DocumentFactory Factory'    at org.apache.poi.xssf.usermodel.XSSFPivotCacheDefinition.readFrom(XSSFPivotCacheDefinition.java:79)    at org.apache.poi.xssf.usermodel.XSSFPivotCacheDefinition.<init>(XSSFPivotCacheDefinition.java:69)    at org.apache.poi.ooxml.POIXMLFactory.createDocumentPart(POIXMLFactory.java:61)    at org.apache.poi.ooxml.POIXMLDocumentPart.read(POIXMLDocumentPart.java:661)    at org.apache.poi.ooxml.POIXMLDocument.load(POIXMLDocument.java:165)    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:259)    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:310)    at excelimporter.reader.readers.ExcelXLSXDataReader$1.<init>(ExcelXLSXDataReader.java:51)    at excelimporter.reader.readers.ExcelXLSXDataReader.parseExcelFile(ExcelXLSXDataReader.java:51)    at excelimporter.reader.readers.ExcelXLSXDataReader.readDataRows(ExcelXLSXDataReader.java:45)    at excelimporter.reader.readers.ExcelReader.importData(ExcelReader.java:364)    at excelimporter.reader.ExcelImporter.startImport(ExcelImporter.java:118)    at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:61)    at excelimporter.actions.StartImportByTemplate.executeAction(StartImportByTemplate.java:25)    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:73)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:81)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:123)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:123)    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:58)    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35)    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11)    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:29)    at scala.Option.flatMap(Option.scala:283)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:26)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:201)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeMicroflow(MicroflowImpl.scala:134)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAction$1(MicroflowImpl.scala:114)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.$anonfun$withSpan$1(OpenTelemetryUtil.scala:18)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.$anonfun$usingSpanWithCustomStatus$2(OpenTelemetryUtil.scala:37)    at scala.util.Using$.apply(Using.scala:296)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.usingSpanWithCustomStatus(OpenTelemetryUtil.scala:36)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.usingSpanWithCustomStatus(OpenTelemetryUtil.scala:53)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.withSpanWithCustomStatus(OpenTelemetryUtil.scala:15)    at com.mendix.modules.opentelemetry.OpenTelemetryUtil$.withSpan(OpenTelemetryUtil.scala:18)    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:112)    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:73)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:81)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:60)    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52)    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:60)    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:47)    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:81)    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeAsync$3(ActionManager.scala:105)    at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:687)    at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:467)    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)    at java.base/java.lang.Thread.run(Thread.java:1583)

asked 2025-07-04

2 answers