apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile

For poi-4.1.0 I had to add these to the classpath:
dom4j-1.6.jar
xmlbeans-3.1.0.jar
commons-collections4-4.3.jar
commons-compress-1.18.jar
Only then did this work for Excel.xlsx File:

ExcelWBook = new XSSFWorkbook(ExcelFile);

Leave a Comment