java自定义模版导出Excel

小鱼儿 2023-09-29 18:08 39阅读 0赞

参考 [关于Easyexcel | Easy Excel][Easyexcel _ Easy Excel]

#### 一、引入 pom.xml ####

<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>2.2.10</version>
    </dependency>

#### 二、自定义模版 ####

![f4e23e35ccff43d0a15d23fef0db856d.png][]

#### 三、测试示例 ####

import com.alibaba.excel.EasyExcel;
    import com.alibaba.excel.ExcelWriter;
    import com.alibaba.excel.write.metadata.WriteSheet;
    import com.alibaba.excel.write.metadata.fill.FillWrapper;
    import lombok.Data;
    import java.util.ArrayList;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    
    public class ExcelUtil {
    
        public static void main(String[] args) {
            // 模板文件路径
            String tempFilePath = "/Users/sunny/templates/exportExcelTemplate.xlsx";
            // 导出目标文件
            String excelFileName = "/Users/sunny/templates/测试导出Excel.xlsx";
            // 根据模板文件生成目标文件
            ExcelWriter excelWriter = EasyExcel
                    .write(excelFileName)
                    .withTemplate(tempFilePath)
                    .build();
            WriteSheet writeSheet = EasyExcel.writerSheet().build();
    
            // 测试数据
            List<UserTest> list = new ArrayList<>();
            for (int i = 0; i < 10; i++) {
                UserTest userTest = new UserTest();
                userTest.setName("测试" + i);
                userTest.setAge(25 + i);
                userTest.setAddress("北京" + i);
                list.add(userTest);
            }
    
            // 第一种
            Map<String, List<?>> map = new HashMap<>();
            map.put("data", list);
            map.forEach((k, v) -> excelWriter.fill(new FillWrapper(k, v), writeSheet));
    
            // 第二种
            // excelWriter.fill(new FillWrapper("data", list), writeSheet);
    
            excelWriter.finish();
        }
    }
    
    @Data
    class UserTest {
        private String name;
        private Integer age;
        private String address;
    }

#### 四、导出结果 ####

![e4b4aaa81458413e9cbaf35c005b4663.png][]

[Easyexcel _ Easy Excel]: https://easyexcel.opensource.alibaba.com/docs/current/
[f4e23e35ccff43d0a15d23fef0db856d.png]: https://img-blog.csdnimg.cn/f4e23e35ccff43d0a15d23fef0db856d.png
[e4b4aaa81458413e9cbaf35c005b4663.png]: https://img-blog.csdnimg.cn/e4b4aaa81458413e9cbaf35c005b4663.png