读取excel文件时Apache POI NoClassDefFoundError [英] Apache POI NoClassDefFoundError while reading excel files

问题描述

我正在尝试运行此代码:

I am attempting to run this code:

public class ExcelSimpleTest {
    public static void main(String[] args) throws  Exception {
          File f = new File("C:\\Users\\yaron\\Desktop\\Test.xlsx");
          FileInputStream fis = new FileInputStream(f);

          XSSFWorkbook wb=new XSSFWorkbook(fis);
          Sheet sheet=wb.getSheetAt(0);
          System.out.println(sheet.getRow(0).getCell(0).getStringCellValue());
    }

}

并且我收到此错误:

    Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
    at src.ExcelSimpleTest.main(ExcelSimpleTest.java:22)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    ... 1 more

我在互联网上查看并复制了 Apache POI 文件，但不明白我的问题是什么.

I checked on the internet and copied over the Apache POI files and don't understand what my problem is.

推荐答案

看来您错过了类路径中的 commons-collection4.jar.下载它并将其添加到您的类路径中.如果您使用 maven，则可以添加

It Looks like you miss the commons-collection4.jar in your classpath. Download it and add it to your classpath. If you use maven you can add

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

到你的 pom.

如果没有，您可以在这里下载

这篇关于读取excel文件时Apache POI NoClassDefFoundError的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！