topic Re: Help Tjava using POI 5.2.3 export Excel in Talend 6.3 in Talend Studio

Help Tjava using POI 5.2.3 export Excel in Talend 6.3

ngoctuan04th2 — Fri, 15 Nov 2024 21:18:59 GMT

Dear all,

I using Talen 6.3 , I want to using POI version 5.2.3 to export excel in Tjava component.

3- then in Tjava_3 component i write command : XSSFWorkbook workbook = new XSSFWorkbook();

Unfortunately, i meet error bellow :

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/logging/log4j/LogManager

at org.apache.poi.ss.usermodel.DataFormatter.<clinit>(DataFormatter.java:228)

at org.apache.poi.ss.formula.functions.TextFunction.<clinit>(TextFunction.java:33)

at org.apache.poi.ss.formula.atp.AnalysisToolPak.createFunctionsMap(AnalysisToolPak.java:84)

Please help me to resolve it.

Thank you!

Anonymous — Mon, 23 Oct 2023 09:14:58 GMT

The error indicates the job is missing a jar containing class org/apache/logging/log4j/LogManager.

ngoctuan04th2 — Tue, 24 Oct 2023 01:36:38 GMT

Dear,

Can you help me how to resolve it, add file jar. because i'm beginer talend, so not clearly about it.

Thank you

Anonymous — Wed, 25 Oct 2023 08:07:19 GMT

You are using an old Talend version 6.3, maybe the version of log4j jar files is not compatible with your Java version.