[resolved] IMPORTING ORG.APACHE.POI

Anonymous — Sat, 16 Nov 2024 10:26:40 GMT

Hi Guys,
My Talend Studio is version 6.1.1. I created a Routines and IMPORTED or required a org.apache.poi. below are the following:
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellReference;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Basically its for reading a Excel files. At first this Routines are working well and no error. But when I restarted my Talend and re-open my Routines. An error occurred and I cannot run anymore my JOB because the Routines is not functioning well.
The error is: talend Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook
Im reading and searching in google how to fix this, they say that you need the following:
1)poi-3.6-20091214.jar
2)poi-contrib-3.6-20091214.jar
3)poi-examples-3.6-20091214.jar
4)poi-ooxml-3.6-20091214.jar
5)poi-ooxml-schemas-3. 6-20091214.jar
6)poi-scratchpad-3.6-20091214.jar
7. xmlbeans

My questions is how can you know your POI Version and where to put this all?

Thanks

Re: [resolved] IMPORTING ORG.APACHE.POI

Anonymous — Fri, 19 Aug 2016 01:36:06 GMT

They also say that you need the following in C:\TOS_DI-20151214_1327-V6.1.1\plugins\ org.talend.libraries.excel_6.1.1.20151214_1327\lib
I have the following inside:
poi-3.10.1.jar
poi-3.11-20141221_modified_talend.jar
poi-ooxml-3.11-20141221_modified_talend.jar
poi-ooxml-schemas-3.11-20141221.jar
poi-scratchpad-3.11-20141221.jar
simpleexcel.jar
talendExcel.jar

Re: [resolved] IMPORTING ORG.APACHE.POI

talendtester — Wed, 02 Nov 2022 19:22:00 GMT

Turn off "Read excel 2007 file format (xlsx)" on your tFileInputExcel.

topic Re: [resolved] IMPORTING ORG.APACHE.POI in Talend Studio

[resolved] IMPORTING ORG.APACHE.POI

Re: [resolved] IMPORTING ORG.APACHE.POI

Re: [resolved] IMPORTING ORG.APACHE.POI