POI 报错: org.apache.commons.collections4.ListValuedMap

ゝ一纸荒年。 2023-10-13 17:03 7阅读 0赞

### 一，错误：org.apache.commons.collections4.ListValuedMap ###

> Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap

###### 代码参考：[java实现excel项目导入导出源码][java_excel]（https://blog.csdn.net/laterstage/article/details/131713449?spm=1001.2014.3001.5502） ######

### 第一种：解决方法：将下面jar包换成统一版本 ###

<dependency>
         <groupId>org.apache.poi</groupId>
         <artifactId>poi</artifactId>
         <version>4.1.0</version>
     </dependency>
     <dependency>
         <groupId>org.apache.poi</groupId>
         <artifactId>poi-ooxml</artifactId>
         <version>4.1.0</version>
     </dependency>
     <dependency>
         <groupId>org.apache.poi</groupId>
         <artifactId>poi-ooxml-schemas</artifactId>
         <version>4.1.0</version>
    
     </dependency>

### 第二种：博主实现excle导入，导出的pom（如果上面，更改完毕还有问题，可以直接替换下面的pom依赖） ###

<dependency>
          <groupId>org.apache.poi</groupId>
          <artifactId>poi</artifactId>
          <version>4.1.0</version>
        </dependency>
        <dependency>
          <groupId>org.apache.poi</groupId>
          <artifactId>poi-ooxml</artifactId>
          <version>4.1.0</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-collections4</artifactId>
          <version>4.1</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-compress</artifactId>
          <version>1.18</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-math3</artifactId>
          <version>3.6.1</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.commons</groupId>
          <artifactId>commons-math3</artifactId>
          <version>3.6.1</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.poi</groupId>
          <artifactId>poi-ooxml-schemas</artifactId>
          <version>4.1.2</version>
        </dependency>
    
        <dependency>
          <groupId>org.apache.xmlbeans</groupId>
          <artifactId>xmlbeans</artifactId>
          <version>3.1.0</version>
        </dependency>

> 如果只是实现excel的导入与导出，可以直接使用下面的pom

[java_excel]: https://blog.csdn.net/laterstage/article/details/131713449?spm=1001.2014.3001.5502