Error on running app local after installing Excel Import Widget

0
Hello,   I am using Mendix Studio 10.18.1 and after downloading the excel importer plugin from the Marketplace. After the installation I have fixed the two errors.  It's not possible to start the application locally. After removing the excel importer plugin it's possible to start the app locally.   I got following error message and I have no idea to solve it. Do you have any hint for me, thanks.   C:\Projekte\CBAM-Wizzard-main\javasource\excelimporter\reader\readers\ExcelXLSXDataReader.java:51: error: getNameIndex(String) in XSSFWorkbook cannot implement getNameIndex(String) in Workbook        try (XSSFWorkbook workbook = new XSSFWorkbook(excelFile) {                                                                 ^  attempting to assign weaker access privileges; was publicC:\Projekte\CBAM-Wizzard-main\javasource\excelimporter\reader\readers\ExcelXLSXDataReader.java:68: error: cannot find symbol                XMLReader sheetParser = XMLHelper.newXMLReader();                                                 ^  symbol:   method newXMLReader()  location: class XMLHelperNote: Some input files use or override a deprecated API.Note: Recompile with -Xlint:deprecation for details.Note: Some input files use unchecked or unsafe operations.Note: Recompile with -Xlint:unchecked for details.2 errors FAILURE: Build failed with an exception. * What went wrong:Execution failed for task ':compile'.> Compilation failed; see the compiler error output for details. * Try:> Run with --scan to get full insights. BUILD FAILED in 19s    
asked
4 answers
0

I have the same error message now using Mendix 10.24.9 after upgrading from 9.24.35. I also updated the excel import module to the last version. Did you find out something? Thank you in advance.

answered
0

In the release notes, the following java files have been upgraded. Can you ensure there are no duplicates in your userlib folder?

- Upgraded commons-lang3 jar version to v3.18.0

 

There are also additional dependencies mentioned in Section 2 of the documentation Excel Importer Documentation

answered
0

I have the same problem after upgrading the Excel Importer. 

- Running Mx 9.24.40.

- Used to mendix-userlib-cleaner to remove duplicates. Everything worked after cleaning, before upgrading.

- Also checked dependencies as mentioned above.

 

Error:

\javasource\excelimporter\reader\readers\ExcelXLSXDataReader.java:68: error: cannot find symbol

                XMLReader sheetParser = XMLHelper.newXMLReader();

                                                 ^

  symbol:   method newXMLReader()

  location: class XMLHelper

Note: Some input files use or override a deprecated API.

Note: Recompile with -Xlint:deprecation for details.

Note: Some input files use unchecked or unsafe operations.

Note: Recompile with -Xlint:unchecked for details.

1 error

 

What I found in userlib was the following:

Think this could be conflicting because there are two ooxml versions? But how to resolve? Removing ooxml-4.1.1 will give another compile error because ooxml-schemas is depending on this one.

 

Or couldn't this be the problem?

Screenshot 2025-12-08 at 16.31.00.png

answered
0

Solved my problem. It was in the conflicting poi-ooxml.

 

Solution

  • I deleted all old versions (4.1.1) from poi, poi-ooxml and poi-ooxml-schemas.
  • Then I installed Excel Importer and Excel Exporter again (probably not necessary)
  • Checked if there where no duplicated versions of poi anymore
  • Could build again :)

 

answered