项目有需求需要支持excel导入导出功能,导出有个组员先做了,但是他用的是低版本的poi。后面让我来做导入功能,我用的easyexcel来做,easyexel的poi版本又比较高。导致poi版本不一致造成了冲突,又因为导出是基于引入的平台jar做的,他那边也不想改源码,就只有我自己搞了。
网上搜了很多方法都不管用,最后还是靠大佬说的直接改easyexcel源码中的依赖,将poi依赖jar改成自定义的jar路径,就不会涉及到会导成其他版本poi的bug了。但是美中不足的是大佬们都是授人以渔的,没有现成的文件(虽然说工具都提供了)。在自己试错了很多次后终于搞出来了一个自用版本的easyexcel。也就供大家下载吧。(但是因为最近太忙了,时间也有点久远,可能有的说法或步骤有问题,大佬们多多见谅......)
ps:
自己项目引入改好的easyexcel包后,在搭建时可能会报一些错误,一般百度可解决,有可能就是差了一些jar包。我这个项目是差了这个jar包:
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-collections4</artifactId>
<version>4.1</version>
</dependency>
=========================================================================
分享一些可能会遇到的坑:
1.
这一步容易输入没反应还是啥,请将复制的 "-" 删掉再手动敲一个"-"即可(只用改-jar前面那个-即可)
2.
原文只提供了一个rule的写法,当时我后面参照着写又搞出了一大堆毛病,还是附一个后续rule的写法吧......(应该是对的,注意每次执行的时候改成你保存这个rule的文件名哈)
rule org.apache.poi.** com.mytest.poi.@1
rule org.apache.poi.ooxml.** com.mytest.poi-ooxml.@1
rule org.apache.poi.ooxml.schemas.** com.mytest.poi-ooxml-schemas.@1
3.
自己去github把easyexcel的源码down下来,这一步应该就不用我多做了吧......然后修改pom中对应的原有的依赖,引入本地jar。
注意修改项目那些类的import导入路径,用 ctrl+shift+r 全局替换
大概长这样?太久远我也忘了,反正只要启动不爆红就行......
我自己的项目结构是这样的
附:本地jar引入的pom文件写法(或者groupId可以改一下?可能会有bug,我才疏学浅):
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-3.17.jar
</systemPath>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi-ooxml</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-ooxml-3.17.jar
</systemPath>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi-ooxml-schemas</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-ooxml-schemas-3.17.jar
</systemPath>
</dependency>
此时建议启动一下项目,看有没有报错啥的,当时我又差了一个jar包......反正百度完错误加上去就行了
还是附上一个完整的pom文件吧:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
<packaging>jar</packaging>
<name>easyexcel</name>
<description>easyexcel is a excel handle tools written in Java</description>
<url>https://github.com/alibaba/easyexcel</url>
<inceptionYear>2018</inceptionYear>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<jdk.version>1.6</jdk.version>
<gpg.skip>true</gpg.skip>
<maven.javadoc.skip>true</maven.javadoc.skip>
</properties>
<scm>
<url>https://github.com/alibaba/easyexcel</url>
<connection>scm:git:https://git@github.com/alibaba/easyexcel.git</connection>
</scm>
<!--<repositories>-->
<!--<repository>-->
<!--<id>local-file</id>-->
<!--<url>file://${basedir}/lib/</url>-->
<!--<layout>default</layout>-->
<!--</repository>-->
<!--</repositories>-->
<organization>
<name>Alibaba Group</name>
<url>https://github.com/alibaba</url>
</organization>
<developers>
<developer>
<id>jipengfei</id>
<name>jipengfei</name>
<email>1558143046@qq.com</email>
</developer>
</developers>
<licenses>
<license>
<name>Apache 2</name>
<url>http://www.apache.org/licenses/LICENSE-2.0.txt</url>
<distribution>repo</distribution>
<comments>A business-friendly OSS license</comments>
</license>
</licenses>
<dependencies>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-3.17.jar
</systemPath>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi-ooxml</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-ooxml-3.17.jar
</systemPath>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>my-poi-ooxml-schemas</artifactId>
<version>3.17</version>
<scope>system</scope>
<systemPath>${project.basedir}/lib/my-poi-ooxml-schemas-3.17.jar
</systemPath>
</dependency>
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>3.1</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.26</version>
</dependency>
<dependency>
<groupId>org.ehcache</groupId>
<artifactId>ehcache</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>org.apache.xmlbeans</groupId>
<artifactId>xmlbeans</artifactId>
<version>2.3.0</version>
</dependency>
<!--test-->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.71</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.8</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot</artifactId>
<version>1.5.21.RELEASE</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>1.5.21.RELEASE</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
<distributionManagement>
<snapshotRepository>
<id>ossrh</id>
<url>https://oss.sonatype.org/content/repositories/snapshots</url>
</snapshotRepository>
<repository>
<id>ossrh</id>
<url>https://oss.sonatype.org/service/local/staging/deploy/maven2/</url>
</repository>
</distributionManagement>
<build>
<plugins>
<!-- code style -->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-pmd-plugin</artifactId>
<version>3.8</version>
<configuration>
<printFailingErrors>true</printFailingErrors>
<verbose>true</verbose>
<rulesets>
<ruleset>rulesets/java/ali-comment.xml</ruleset>
<ruleset>rulesets/java/ali-concurrent.xml</ruleset>
<ruleset>rulesets/java/ali-constant.xml</ruleset>
<ruleset>rulesets/java/ali-exception.xml</ruleset>
<ruleset>rulesets/java/ali-flowcontrol.xml</ruleset>
<ruleset>rulesets/java/ali-naming.xml</ruleset>
<ruleset>rulesets/java/ali-oop.xml</ruleset>
<ruleset>rulesets/java/ali-orm.xml</ruleset>
<ruleset>rulesets/java/ali-other.xml</ruleset>
<ruleset>rulesets/java/ali-set.xml</ruleset>
</rulesets>
<excludes>
<exclude>com/alibaba/excel/event/AnalysisEventListener.java</exclude>
<exclude>com/alibaba/excel/metadata/DataFormatter.java</exclude>
<exclude>com/alibaba/excel/util/DateUtils.java</exclude>
<exclude>com/alibaba/excel/metadata/format/DataFormatter.java</exclude>
<exclude>com/alibaba/excel/metadata/format/ExcelGeneralNumberFormat.java</exclude>
</excludes>
</configuration>
<executions>
<execution>
<id>pmd-check-verify</id>
<phase>validate</phase>
<goals>
<goal>check</goal>
</goals>
</execution>
</executions>
<dependencies>
<dependency>
<groupId>com.alibaba.p3c</groupId>
<artifactId>p3c-pmd</artifactId>
<version>1.3.6</version>
</dependency>
</dependencies>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.6</source>
<target>1.6</target>
</configuration>
</plugin>
<plugin>
<artifactId>maven-source-plugin</artifactId>
<version>2.1</version>
<configuration>
<attach>true</attach>
</configuration>
<executions>
<execution>
<phase>compile</phase>
<goals>
<goal>jar</goal>
</goals>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-gpg-plugin</artifactId>
<version>1.6</version>
<executions>
<execution>
<phase>verify</phase>
<goals>
<goal>sign</goal>
</goals>
</execution>
</executions>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-javadoc-plugin</artifactId>
<version>3.1.0</version>
<executions>
<execution>
<id>attach-javadocs</id>
<goals>
<goal>jar</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
最后项目启动不爆红就行,然后打个jar包,把这4个jar包扔进自己的项目就行了~~~
最后在自己写的模块里把需要引入的相关类的路径改成现在导入的包路径即可(就是import时看仔细,别选成老的apache的就行)
=========================================================================
文末:
感谢阅读新人写的第一篇文章,一直都在白 p 大佬们写的资料,之前在搞这个的时候也发现有人在说虽然有大佬提供了相应的工具,但是自己没时间去搞这些,想要现成的文件。最近项目交付了没这么忙了,也一直在写相关写代码心得。这次终于也能浅浅的贡献一下自己的代码了~
我敲代码的时间也不长,很多地方可能有误,表达方式不对。望各位海涵。
=========================================================================
自用版本的easyexcel下载链接:
https://pan.baidu.com/s/1YLxgLbS0tI4vLkAxHOB1yg?pwd=neu9
提取码: neu9
参考的链接:jar包冲突解决方案——jar包名修改兼容实现_ooxml-schemas_laodagewo的博客-CSDN博客