Apache POI error loading XSSFWorkbook class

Question

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

User · Answer

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    lt  -- https   mvnrepository com artifact org apache commons commons-collections4 -- gt    lt dependency gt      lt groupId gt org apache commons lt  groupId gt      lt artifactId gt commons-collections4 lt  artifactId gt      lt version gt 4 1 lt  version gt   lt  dependency gt

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

[java] Apache POI error loading XSSFWorkbook class

Examples related to java

Examples related to apache

Examples related to apache-poi

Examples related to xssf