POI实现Excel导入时提示NoSuchMethodError: org.apache.poi.util.POILogger.log

您所在的位置:网站首页 javapoi导入excel POI实现Excel导入时提示NoSuchMethodError: org.apache.poi.util.POILogger.log

POI实现Excel导入时提示NoSuchMethodError: org.apache.poi.util.POILogger.log

2023-03-24 21:34| 来源: 网络整理| 查看: 265

POI实现Excel导入时提示NoSuchMethodError: org.apache.poi.util.POILogger.log 原创

霸道流氓 2023-03-24 17:42:16 博主文章分类:架构之路 ©著作权

文章标签 poi java apache jar 文章分类 JavaScript 前端开发

©著作权归作者所有:来自51CTO博客作者霸道流氓的原创作品,请联系作者获取转载授权,否则将追究法律责任

场景

SpringBoot中使用POI实现Excel导入到数据库(图文教程已实践)

在进行解析Excel时提示:

Caused by: java.lang.NoSuchMethodError: org.apache.poi.util.POILogger.log(ILjava/lang/Object;)V at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.parseRelationshipsPart(PackageRelationshipCollection.java:304) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.(PackageRelationshipCollection.java:156) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackageRelationshipCollection.(PackageRelationshipCollection.java:124) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackagePart.loadRelationships(PackagePart.java:559) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackagePart.(PackagePart.java:112) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackagePart.(PackagePart.java:83) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.PackagePart.(PackagePart.java:128) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.ZipPackagePart.(ZipPackagePart.java:78) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:218) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:662) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:269) ~[poi-ooxml-3.9.jar:3.9] at org.apache.poi.util.PackageHelper.open(PackageHelper.java:39) ~[poi-ooxml-3.9.jar:3.16] at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:204) ~[poi-ooxml-3.9.jar:3.9] at com.ws.bus.sys.controller.WmsReceiveOrderController.parseExcel(WmsReceiveOrderController.java:206) ~[classes/:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_112] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_112] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_112] at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_112] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209) ~[spring-web-5.0.7.RELEASE.jar:5.0.7.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) ~[spring-web-5.0.7.RELEASE.jar:5.0.7.RELEASE]

定位到出现错误的地方为:

POI实现Excel导入时提示NoSuchMethodError: org.apache.poi.util.POILogger.log_jar

解决

找到项目的pom.xml部分

项目所需依赖为:

org.apache.poi poi 3.9 org.apache.poi poi-ooxml 3.9 org.apache.poi poi-ooxml-schemas 3.9

但是除此之外还导入了一个

org.apache.poi poi 3.16

导致版本冲突。

收藏 评论 分享 举报

上一篇:SpringBoot中配置为开发模式,代码修改后不用重新运行

下一篇:SpringBoot中使用log4j进行日志管理



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3