java使用easyexcel通过模板导出excel(基于若依)

1.准备excel模板

 

 

 

 

注：  数据类型为map用{}，数据类型为List用{.}

2.在项目中resource目录下新建目录static，然后把准备好的模板扔进去

3.maven中添加相关依赖

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.6</version>
            <exclusions>
                <exclusion>
                    <groupId>org.apache.poi</groupId>
                    <artifactId>poi</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.apache.poi</groupId>
                    <artifactId>poi-ooxml</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.ehcache</groupId>
                    <artifactId>ehcache</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

4.导出excel并返回文件名称供前端下载

public AjaxResult test(Map map,List list) throws IOException {
    InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("static/"+"test.xlsx");
    String fileName = UUID.randomUUID().toString() + "_" + "test.xlsx";
    String downloadPath = RuoYiConfig.getDownloadPath() + fileName;
    OutputStream out=new FileOutputStream(downloadPath);
    ExcelWriter excelWriter = EasyExcel.write(out).withTemplate(inputStream).build();
    WriteSheet writeSheet = EasyExcel.writerSheet().build();
    excelWriter.fill(list, writeSheet);
    excelWriter.fill(map, writeSheet);
    excelWriter.finish();
    return AjaxResult.success(fileName);
}

 5.结果：