EasyExcel多版本poi共存

修改poi的包名

可以查看我这篇文章https://blog.csdn.net/qq_23888451/article/details/123408956

打包到本地仓库

mvn install:install-file -Dfile=my-poi-4.1.2.jar -DgroupId=com.yootii -DartifactId=poi -Dversion=4.1.2 -Dpackaging=jar

mvn install:install-file -Dfile=my-poi-ooxml-4.1.2.jar -DgroupId=com.yootii -DartifactId=poi-ooxml -Dversion=4.1.2 -Dpackaging=jar

mvn install:install-file -Dfile=my-poi-schemas-4.1.2.jar -DgroupId=com.yootii -DartifactId=poi-ooxml-schemas -Dversion=4.1.2 -Dpackaging=jar

重新编译打包easyExcel

下载源码

https://github.com/alibaba/easyexcel

修改pom依赖

        <!-- 修改poi jar com.my-->
		<dependency>
            <groupId>com.my</groupId>
            <artifactId>poi</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
            <groupId>com.my</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.1.2</version>
        </dependency>
        <dependency>
            <groupId>com.my</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>4.1.2</version>
        </dependency>
        <!-- 添加下面jar 或者编译时报哪个类找不到时再添加-->
		<dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-collections4</artifactId>
            <version>4.4</version>
        </dependency>
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-compress</artifactId>
            <version>1.21</version>
        </dependency>
        <dependency>
            <groupId>org.apache.xmlbeans</groupId>
            <artifactId>xmlbeans</artifactId>
            <version>3.1.0</version>
        </dependency>

修改项目groupId

修改import名称

编译打包

mvn packge
将jar包加入本地仓库

mvn install:install-file -Dfile=easyexcel-3.0.5.jar -DgroupId=com.my -DartifactId=easyexcel -Dversion=3.0.5 -Dpackaging=jar

使用

pom文件

		<dependency>
			<groupId>com.my</groupId>
			<artifactId>easyexcel</artifactId>
			<version>3.0.5</version>
		</dependency>
		<dependency>
			<groupId>com.my</groupId>
			<artifactId>poi</artifactId>
			<version>4.1.2</version>
		</dependency>
		<dependency>
			<groupId>com.my</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>4.1.2</version>
		</dependency>
		<dependency>
			<groupId>com.my</groupId>
			<artifactId>poi-ooxml-schemas</artifactId>
			<version>4.1.2</version>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-collections4</artifactId>
			<version>4.4</version>
		</dependency>
		<dependency>
			<groupId>org.apache.commons</groupId>
			<artifactId>commons-compress</artifactId>
			<version>1.21</version>
		</dependency>
		<!-- xmlbeans 2.+ 4.+ 5.+版本都会报错，只有3+版本可以用 -->
		<dependency>
			<groupId>org.apache.xmlbeans</groupId>
			<artifactId>xmlbeans</artifactId>
			<version>3.1.0</version>
		</dependency>

Excelutil类

package com.zz.util;

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.util.ListUtils;

import java.util.Date;
import java.util.List;

public class EasyExcelUtil {
    private static List<List<Object>> dataList() {
        List<List<Object>> list = ListUtils.newArrayList();
        for (int i = 0; i < 100; i++) {
            List<Object> data = ListUtils.newArrayList();
            data.add("字符串" + i);
            data.add(new Date());
            data.add(0.56);
            list.add(data);
        }
        return list;
    }
    public static void noModelWrite2() {
        // 写法1
        String fileName = "d:/doc/noModelWrite" + System.currentTimeMillis() + ".xlsx";
        // 这里 需要指定写用哪个class去写，然后写到第一个sheet，名字为模板 然后文件流会自动关闭
        EasyExcel.write(fileName).head(head()).sheet("模板").doWrite(dataList());
    }
    private static List<List<String>> head() {
        List<List<String>> list = ListUtils.newArrayList();
        List<String> head0 = ListUtils.newArrayList();
        head0.add("字符串" + System.currentTimeMillis());
        List<String> head1 = ListUtils.newArrayList();
        head1.add("数字" + System.currentTimeMillis());
        List<String> head2 = ListUtils.newArrayList();
        head2.add("日期" + System.currentTimeMillis());
        list.add(head0);
        list.add(head1);
        list.add(head2);
        return list;
    }
    public static void main(String[] args) {
        long startTime = System.currentTimeMillis();
        noModelWrite2();
        System.out.println(System.currentTimeMillis() - startTime);
    }
}

自定义的easyexcel-3.0.5.jar，我上传到云盘上了，如果用可以直接拿去用

链接：https://pan.baidu.com/s/1JPBEuByEv_PHkRxD3_MDxQ 
提取码：jv8v