
Anonymous
Not applicable
2016-08-18
09:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[resolved] IMPORTING ORG.APACHE.POI
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
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
1,151 Views
2 Replies

Anonymous
Not applicable
2016-08-18
09:36 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
1,151 Views

Creator III
2022-11-02
03:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Turn off "Read excel 2007 file format (xlsx)" on your tFileInputExcel.
1,151 Views
