Error on Reading the Xls file | Selenium Forum
M
Posted on 17/09/2015
Code

public class file_reader {

public static void main(String[] args) {


Xls_Reader xls = new Xls_Reader("C:\\Users\\Archana\\Desktop\\salenium\\Data.xlsx");

// rows
int rows = xls.getRowCount("LoginTest");
int cols = xls.getColumnCount("LoginTest");
System.out.println("Total rows -> "+ rows);
System.out.println("Total cols -> "+ cols);

String data = xls.getCellData("LoginTest", "Username", 4);
System.out.println(data);
String data1 = xls.getCellData("LoginTest", "password", 4);
System.out.println(data1);

data1 = xls.getCellData("LoginTest", 2, 3);
System.out.println(data1);

xls.setCellData("LoginTest", "Password", 10, "hello");

}

}

===========================Error message==============
Exception in thread "main" java.lang.NoClassDefFoundError: org/dom4j/DocumentException
at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:149)
at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:136)
at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:54)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:98)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:199)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:178)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:53)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:176)
at Xls_Reader.<init>(Xls_Reader.java:33)
at file_reader.main(file_reader.java:7)
Caused by: java.lang.ClassNotFoundException: org.dom4j.DocumentException
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 10 more
==================Solution please===============

M
Replied on 18/09/2015

chk 2 things

first the path of Data.xlsx file

second see f all the jar files are added in your library.