Apache POI error loading XSSFWorkbook class

java apache apache-poi xssf
Cameron Zach picture Cameron Zach · Sep 24, 2016 · Viewed 109.9k times · Source

I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my requirements. I'm attempting to move to XSSF, but I keep getting errors when trying to use it.

I managed to solve the first two by adding xmlbeans-2.3.0.jar and dom4j-1.6.jar to my program, but now this error is coming up, which doesn't seem to be resolved by adding the Apache commons jar available on the Apache website.

The error is as follows:

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
    at hot.memes.ExcelCreator.main(ExcelCreator.java:66)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 1 more

Answer

Lakhwinder Sharma picture Lakhwinder Sharma · Sep 24, 2016

Add commons-collections4-x.x.jar file in your build path and try it again. It will work.

You can download it from https://mvnrepository.com/artifact/org.apache.commons/commons-collections4/4.0

Related questions

Apache POI XSSF reading in excel files

I just have a quick question about how to read in an xlsx file using the XSSF format from Apache. Right now my code looks like this: InputStream fs = new FileInputStream(filename); // (1) XSSFWorkbook wb = new XSSFWorkbook(fs); // (2) XSSFSheet sheet = wb.…

Read More
Apache POI, using both XSSF and HSSF

I have a problem with Apache POI project. I failed to use XSSF and HSSF in the "Same Java Class". Which jar should I download or which artifact should I get add into maven? I want to handle both xls …

Read More
How to get the position/index of a Sheet object in Java Apache POI

In a Java method I am using an Apache POI Sheet (from XSSFWorkbook). I can read the sheet name using getSheetName() method. But is there any way to find the sheet position in the workbook. I don't see any methods …

Read More