Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (6)
2 Replies
Anonymous
Not applicable
Author

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
talendtester
Creator III

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