Apache POI error loading XSSFWorkbook class

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

commons-collections4-x.x.jar definitely solve this problem but Apache has removed the Interface ListValuedMap from commons-Collections4-4.0.jar so use updated version 4.1 it has the required classes and Interfaces.

Refer here if you want to read Excel (2003 or 2007+) using java code.

http://www.codejava.net/coding/how-to-read-excel-files-in-java-using-apache-poi

Hurrah! Adding commons-collections jar files to my project resolved this problem. Two thumbs up to Lucky Sharma.

Solution: Add commons-collections4-4.1.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.1

Please note that 4.0 is not sufficient since ListValuedMap, was introduced in version 4.1.

You need to use this maven repository link for version 4.1. Replicated below for convenience

 <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-collections4 -->
 <dependency>
   <groupId>org.apache.commons</groupId>
   <artifactId>commons-collections4</artifactId>
   <version>4.1</version>
</dependency>

Yeah, resolved the exception by adding commons-collections4-4.1 jar file to the CLASSPATH user varible of system. Downloaded from https://mvnrepository.com/artifact/org.apache.commons/commons-collections4/4.1

XSSFWorkbook class is only available in poi-ooxml dependency. Please check if you are using poi or poi-ooxml.

implementation 'org.apache.poi:poi:5.0.0' -> HSSFWorkbook

implementation 'org.apache.poi:poi-ooxml:5.0.0' -> XSSFWorkbook

If you have downloaded pio-3.17 On eclipse: right click on the project folder -> build path -> configure build path -> libraries -> add external jars -> add all the commons jar file from the "lib". It's worked for me.

you have to add jars in your project class classpath -

1. poi-3.17.jar
2. poi-excelant-3.17.jar
3. poi-ooxml-3.17.jar
4. common-collections-4.4.jar
5. xmlbeans-2.3.0.jar
6. poi-ooxml-scehmas-3.17.jar
7. common-compress.jar

There is the following example of your code.

package com.sks.xssbook;

import java.io.File;
import java.io.FileOutputStream;

import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * @author ssuman
 *
 */
public class XssBook1 {

    /**
     * @param args
     */
    public static void main(String[] args) {
        try{
        XSSFWorkbook workBook = new XSSFWorkbook();
        XSSFSheet shhet = workBook.createSheet("sheet1");
        File f1 = new File("sks.xlsx");
        FileOutputStream fileOop = new FileOutputStream(f1);
        workBook.write(fileOop);
        workBook.close();
        System.out.println("File created !!!!!");
        }
        catch(Exception ex) {
            System.err.println("Error ---- "+ex);
        }

    }

}