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

最新推荐文章于 2024-09-27 17:24:11 发布

LXHcode

最新推荐文章于 2024-09-27 17:24:11 发布

阅读量4.1k

点赞数 1

分类专栏： poi 文章标签： java apache

本文链接：https://blog.csdn.net/qq_47469395/article/details/122977664

版权

在尝试使用Apache POI读取Excel时遇到`java.lang.NoSuchMethodError`，通过在pom文件中添加log4j2的版本依赖（<log4j2.version>2.17.1</log4j2.version>）成功解决问题。

摘要由CSDN通过智能技术生成

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

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.logging.log4j.Logger.atDebug()Lorg/apache/logging/log4j/LogBuilder;
	at org.apache.poi.hssf.model.InternalWorkbook.createWorkbook(InternalWorkbook.java:185)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:387)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:347)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
	at org.apache.poi.hssf.usermodel.HSSFWorkbookFactory.create(HSSFWorkbookFactory.java:109)
	at org.apache.poi.ss.usermodel.WorkbookFactory.lambda$create$5(WorkbookFactory.java:318)
	at org.apache.poi.ss.usermodel.Workb