使用poi的小坑，java.lang.NoSuchMethodError

1.  
   public static void main(String[] args) {
2.  
   try {
3.  
   LastUtil.read("D:\\data\\emailFile\\AccountData2022-02-16.xls");
4.  
   } catch (Exception e) {
5.  
   e.printStackTrace();
6.  
   }
7.  
   }

1.  
   Exception in thread "main" java.lang.NoSuchMethodError: org.apache.logging.log4j.Logger.atDebug()Lorg/apache/logging/log4j/LogBuilder;
2.  
   at org.apache.poi.hssf.model.InternalWorkbook.createWorkbook(InternalWorkbook.java:185)
3.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:387)
4.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:347)
5.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
6.  
   at org.apache.poi.hssf.usermodel.HSSFWorkbookFactory.create(HSSFWorkbookFactory.java:109)
7.  
   at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$5(WorkbookFactory.java:318)
8.  
   at org.apache.poi.ss.usermodel.WorkbookFactory.wp(WorkbookFactory.java:329)
9.  
   at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:318)
10.  
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:277)
11.  
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:255)
12.  
    at cn.hasome.mail.util.LastUtil.read(LastUtil.java:17)
13.  
    at cn.hasome.mail.demo.Main.main(Main.java:15)

这是我的pom文件 

1.  
   <?xml version="1.0" encoding="UTF-8"?>
2.  
   <project xmlns="http://maven.apache.org/POM/4.0.0"
3.  
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4.  
   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
5.  
   <modelVersion>4.0.0</modelVersion>
6.  
   <build>
7.  
   <plugins>
8.  
   <plugin>
9.  
   <groupId>org.apache.maven.plugins</groupId>
10.  
    <artifactId>maven-compiler-plugin</artifactId>
11.  
    <configuration>
12.  
    <source>8</source>
13.  
    <target>8</target>
14.  
    </configuration>
15.  
    </plugin>
16.  
    </plugins>
17.  
    </build>
18.  
    <properties>
19.  
    <!-- <log4j2.version>2.17.1</log4j2.version>-->
20.  
    </properties>
21.  
    <parent>
22.  
    <artifactId>spring-boot-parent</artifactId>
23.  
    <groupId>org.springframework.boot</groupId>
24.  
    <version>2.1.3.RELEASE</version>
25.  
    </parent>
26.  
    <groupId>org.example</groupId>
27.  
    <artifactId>springboot-mail</artifactId>
28.  
    <version>1.0-SNAPSHOT</version>
29.  
    <dependencies>
30.  
    <dependency>
31.  
    <groupId>org.springframework.boot</groupId>
32.  
    <artifactId>spring-boot-starter-mail</artifactId>
33.  
    </dependency>
34.  
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
35.  
    <dependency>
36.  
    <groupId>org.apache.poi</groupId>
37.  
    <artifactId>poi</artifactId>
38.  
    <version>5.2.0</version>
39.  
    </dependency>
40.  
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
41.  
    <dependency>
42.  
    <groupId>org.apache.poi</groupId>
43.  
    <artifactId>poi-ooxml</artifactId>
44.  
    <version>5.2.0</version>
45.  
    </dependency>
46.  
    <dependency>
47.  
    <groupId>org.projectlombok</groupId>
48.  
    <artifactId>lombok</artifactId>
49.  
    </dependency>
50.  
    <dependency>
51.  
    <groupId>com.alibaba</groupId>
52.  
    <artifactId>fastjson</artifactId>
53.  
    <version>1.2.70</version>
54.  
    </dependency>
55.  
    <dependency>
56.  
    <groupId>com.谷歌.guava</groupId>
57.  
    <artifactId>guava</artifactId>
58.  
    <version>21.0</version>
59.  
    </dependency>
60.  
    <dependency>
61.  
    <groupId>org.springframework.boot</groupId>
62.  
    <artifactId>spring-boot-starter-web</artifactId>
63.  
    </dependency>
64.  
    <dependency>
65.  
    <groupId>org.springframework.boot</groupId>
66.  
    <artifactId>spring-boot-starter-data-jpa</artifactId>
67.  
    </dependency>
68.  
    <dependency>
69.  
    <groupId>mysql</groupId>
70.  
    <artifactId>mysql-connector-java</artifactId>
71.  
    </dependency>
72.  
    <dependency>
73.  
    <groupId>org.springframework.boot</groupId>
74.  
    <artifactId>spring-boot-starter-test</artifactId>
75.  
    </dependency>
76.  
     
77.  
    </dependencies>
78.  
    </project>

 使用poi读取excel的时候报错，在properties中加入log4j的版本就解决了

<log4j2.version>2.17.1</log4j2.version>
    

这篇好文章是转载于：学新通技术网