Hello
I try to read excel 2007 with Apache POI.
CODE
try {
// Open the Excel file
FileInputStream ExcelFile = new FileInputStream(Path);
// Access the required test data sheet
ExcelWBook = new XSSFWorkbook(ExcelFile); /// error
here
ExcelWSheet = ExcelWBook.getSheet(SheetName);
} catch (Exception e){
I get:
----------------------------------------------------------------------
--- exec-maven-plugin:1.2.1:exec (default-cli) @ Framework ---
Exception in thread "main" java.lang.NoClassDefFoundError:
org/apache/poi/ss/formula/udf/UDFFinder
at utility.ExcelUtils.setExcelFile(ExcelUtils.java:48)
at automationFramework.Apache_POI.main(Apache_POI.java:24)
Caused by: java.lang.ClassNotFoundException:
org.apache.poi.ss.formula.udf.UDFFinder
at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 2 more
------------------------------------------------------------------------
BUILD FAILURE
My JAR list:
org.apache.xmlbeans
poi-ooxml-schemas
ooxml-schemas
org.apache.poi
poi-ooxml
My class starts with:
import java.io.FileInputStream;
import java.io.FileOutputStream;
// import org.apache.poi.xssf.usermodel.XSSFCell;
// import org.apache.poi.xssf.usermodel.XSSFRow;
// import org.apache.poi.xssf.usermodel.XSSFSheet;
// import org.apache.poi.xssf.usermodel.XSSFWorkbook;
//import org.apache.poi.ss.streaming.SXSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Could you please give me a piece of advise which jar I should include ?
thanks!!!
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/I-got-error-NoClassDefFoundError-org-apache-poi-ss-formula-udf-UDFFinder-tp5716761.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
