easyExcel生成动态表头

效果图

如图，问题是可以根据数据自动生成的,只是举了个栗子，可以把表头headers和内容contents根据数据来生成

依赖

        
        <dependency>
            <groupId>cn.hutoolgroupId>
            <artifactId>hutool-allartifactId>
            <version>5.7.13version>
        dependency>
        
        <dependency>
            <groupId>com.alibabagroupId>
            <artifactId>easyexcelartifactId>
            <version>2.2.4version>
        dependency>
1
2
3
4
5
6
7
8
9
10
11
12

代码

import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.write.metadata.WriteSheet;
import com.alibaba.excel.write.metadata.WriteTable;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.util.ArrayList;
import java.util.List;

/**
 * @author: connie1451
 * @copyright:
 * @date: 2022/11/25 16:15
 * */
class Test2 {

    public static void main(String[] args) {
        simpleWrite();
    }

    public static void simpleWrite() {
        //Excel文件输的出位置
        String outPath = "D:/excel/test2.xlsx";
        try {
            //创建ExcelWriter写入对象
            ExcelWriter excelWriter = EasyExcel.write(new FileOutputStream(outPath)).build();

            //创建Sheet对象
            WriteSheet sheet = new WriteSheet();
            //设置第N个Sheet
            sheet.setSheetNo(1);
            //设置Sheet名称
            sheet.setSheetName("第一个Sheet");

            //创建表格对象
            WriteTable table = new WriteTable();
            //设置第N个表格
            table.setTableNo(1);


            //创建表头集合
            List<List<String>> headList = new ArrayList<List<String>>();

            //第N列的表头
            List<String> headTitle1 = new ArrayList<>();
            List<String> headTitle2 = new ArrayList<>();
            List<String> headTitle3 = new ArrayList<>();
            List<String> headTitle4 = new ArrayList<>();
            List<String> headTitle5 = new ArrayList<>();
            List<String> headTitle6 = new ArrayList<>();
            List<String> headTitle7 = new ArrayList<>();
            headTitle1.add("问卷名称");
            //Dau
            headTitle2.add("问题一");
            headTitle2.add("选项1");
            //第三列
            headTitle3.add("问题一");
            headTitle3.add("选项2");

            //第四列
            headTitle4.add("问题一");
            headTitle4.add("选项3");

            //第五列
            headTitle5.add("问题二");
            headTitle5.add("选项1");

            //第六列
            headTitle6.add("问题二");
            headTitle6.add("选项2");

            //第七列
            headTitle7.add("问题二");
            headTitle7.add("选项3");


            headList.add(headTitle1);
            headList.add(headTitle2);
            headList.add(headTitle3);
            headList.add(headTitle4);
            headList.add(headTitle5);
            headList.add(headTitle6);
            headList.add(headTitle7);

            table.setHead(headList);
            List<List<Object>> contents = new ArrayList<>();

            for (int i = 0; i <= 5; i++) {
                List<Object> content = new ArrayList<>();
                for (int j = 0; j < 7; j++) {
                    content.add( + i + "行第" + j + "例");
                }
                contents.add(content);
            }
            excelWriter.write(contents, sheet, table);

            // 记得 释放资源
            excelWriter.finish();
            System.out.println("ok");
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }

    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108