Excel Export in .xlsx failing

1
Hi,  I’m attempting to upgrade the excel exports that the app produces from 97-2003 to 2007 and higher but I’m having some difficulty with what appears to be missing dependencies. I’ve updated to the latest excel exporter (XLS Report) and excel importer just to be sure that there aren’t any compatibility issues but I continue to receive this stacktrace when I use the newer format:    2022-10-18T15:54:46.036+02:00 [APP/PROC/WEB/0] [ERR] ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console… 2022-10-18T15:54:46.433+02:00 [APP/PROC/WEB/0] [OUT] CRITICAL - ActionManager: Error in execution of monitored action 'RegularClientAction' (execution id: 1666101285348-27, execution type: CLIENT) 2022-10-18T15:54:46.433+02:00 [APP/PROC/WEB/0] [OUT] CRITICAL - ActionManager: java.lang.NoSuchFieldError: Factory 2022-10-18T15:54:46.433+02:00 [APP/PROC/WEB/0] [OUT] at org.apache.poi.xssf.usermodel.XSSFWorkbook.onWorkbookCreate(XSSFWorkbook.java:475) 2022-10-18T15:54:46.433+02:00 [APP/PROC/WEB/0] [OUT] at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:232) 2022-10-18T15:54:46.434+02:00 [APP/PROC/WEB/0] [OUT] at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:226) 2022-10-18T15:54:46.434+02:00 [APP/PROC/WEB/0] [OUT] at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:214) 2022-10-18T15:54:46.434+02:00 [APP/PROC/WEB/0] [OUT] at xlsreport.report.export.ExportExcel.<init>(ExportExcel.java:73)   and so on… (if you need the whole stacktrace then let me know).   Any help would be much appreciated!   Thanks,   Andrew
asked
2 answers
1

I see the following dependencies:

 

  • Excel Importer v 10.1.1
  • MxModelReflection v6.2.0
  • Atlas UI Resources v2.6.0

You say you updated the excel importer and exporter, but are the other ones also updated?

answered
0

I mangaed to solve it after trawling around stackoverflow for similar problems. 

The problem was some conflicting .jars presumably imported by updating the Excel Exporter module. I simply removed all references to poi-ooxml-4.1.2.ja in the userlib and the runtime automatically used v5. 

Here is a reference to the stackoverflow post:

apache poi - Exception in thread "main" java.lang.NoSuchFieldError: Factory - Stack Overflow

 

answered