0

While using XSSFWorkbook getting below exception, added org.apache.poi dependancy

my code is as below, it prints projDir and throws exception after that as mentioned below

public class ExcelUtils {
    public static void main(String []args){
            getRowCount();
        }
        public static void getRowCount(){
            try {
            String projDir =System.getProperty("user.dir");
            System.out.println(projDir);
            String excelPath = "./data/TestData.xlsx";
            XSSFWorkbook workbook = new XSSFWorkbook(excelPath);
        } catch (Exception exp) {
            System.out.println(exp.getMessage());
            System.out.println(exp.getCause());
            exp.printStackTrace();
        }
        }
    }

And below is full log track

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.POIXMLDocument.openPackage(POIXMLDocument.java:62)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:188)
    at utils.ExcelUtils.getRowCount(ExcelUtils.java:24)
    at utils.ExcelUtils.main(ExcelUtils.java:11)
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)

0 Answers0