poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexk2 <kar...@yandex.ru>
Subject I got error NoClassDefFoundError: org/apache/poi/ss/formula/udf/UDFFinder
Date Fri, 03 Oct 2014 11:41:50 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message