Apache POI error loading XSSFWorkbook class Apache POI error loading XSSFWorkbook class apache apache

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