Help Tjava using POI 5.2.3 export Excel in Talend 6.3

[ngoctuan04th2]

Dear all,

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

1. i download POI jar
2. i using TloadLibrary to add these jar to project

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]

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

[ngoctuan04th2]

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]

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