EasyExcel两行表头

例子:
在这里插入图片描述
代码:

StorageService localStorageService = storageFactory.getLocalStorageService();
        String path = "";
        // 文件信息
        String dateTime = DateUtils.formatTimestampToString(new Date());
        String title = "xxx统计";
        String fileName = StringUtils.dbc2sbcCase(title) + "_" + dateTime + EXCEL_SUFFIX;

        File file = null;
        ExcelWriter excelWriter = null;
        WriteSheet writeSheet = null;
        int num = 0;
        try {
   
            file = localStorageService.newTempFile(fileName);
            excelWriter = EasyExcel.write(file.getPath()).build();

            writeSheet = EasyExcel.writerSheet(title).sheetNo(0).registerWriteHandler(new CustomizeColumnWidth()).build();

            // 写入数据
            List<List<String>> headList = new ArrayList<>();
            headList.add(Lists.newArrayList(title,"数据1"));
            headList.add(Lists.newArrayList(title,"数据2"));
            headList.add(Lists.newArrayList(title,"数据3"));
            //数据
            List<List<String>> objects = new ArrayList<>();
            objects.add(Lists.newArrayList("123","321","222"));

            WriteTable writeTable = EasyExcel.writerTable(num)
                    .head(headList)
                    .registerWriteHandler(ExcelUtils.getStyleStrategy()).build();
            excelWriter.write(Lists.newArrayList(objects), writeSheet, writeTable);
            num++;

        } catch (Exception e) {
   
            e.printStackTrace();
        }
        if (excelWriter != null) {
   
            // 写入数据
            List<List<String>> headList = new ArrayList<>();
            String tableTitle = "第二个表题";
            headList.add(Lists.newArrayList(tableTitle,"姓名"));
            headList.add(Lists.newArrayList(tableTitle,"年龄"));
            headList.add(Lists.newArrayList(tableTitle,"性别"));
            //数据
            List<List<String>> objects = new ArrayList<>();
            objects.add(Lists.newArrayList("admin","18","男"));
            objects.add(Lists.newArrayList("admin2","19","男"));

            WriteTable writeTable = EasyExcel.writerTable(num)
                    .head(headList)
                    .registerWriteHandler(ExcelUtils.getStyleStrategy()).build();
            excelWriter.write(Lists.newArrayList(objects), writeSheet, writeTable);
            num++;
            try {
   
                excelWriter.finish();
                path = FileUtils.uploadFile(file, fileName, orgId, userId);
            } catch (IOException e) {
   
                e.printStackTrace();
            }
        }
        // 生成的文件的路径
        return path;

重点:

需要合并列的字段重复设到表头中

List<List<String>> headList = new ArrayList<>();
            headList.add(Lists.newArrayList(title,"数据1"));
            headList.add(Lists.newArrayList(title,"数据2"));
            headList.add(Lists.newArrayList(title,"数据3"));

相关推荐

  1. 使用easyexcel对导出表格添加合计

    2023-12-05 17:32:08       55 阅读
  2. EasyExcel表头宽度根据数据内容自适应+自动换

    2023-12-05 17:32:08       63 阅读
  3. EasyExcel表头带动态下拉框导入导出具体实现

    2023-12-05 17:32:08       33 阅读
  4. 阿里 EasyExcel 表头国际化

    2023-12-05 17:32:08       51 阅读

最近更新

  1. docker php8.1+nginx base 镜像 dockerfile 配置

    2023-12-05 17:32:08       94 阅读
  2. Could not load dynamic library ‘cudart64_100.dll‘

    2023-12-05 17:32:08       100 阅读
  3. 在Django里面运行非项目文件

    2023-12-05 17:32:08       82 阅读
  4. Python语言-面向对象

    2023-12-05 17:32:08       91 阅读

热门阅读

  1. linux 路由表的优先级

    2023-12-05 17:32:08       39 阅读
  2. python合并excel

    2023-12-05 17:32:08       57 阅读
  3. sklearn教程:boston波士顿房价数据集

    2023-12-05 17:32:08       55 阅读
  4. Nginx访问控制

    2023-12-05 17:32:08       53 阅读
  5. Native API 在 HarmonyOS 应用工程中的使用指导

    2023-12-05 17:32:08       49 阅读
  6. Oracle 内置sql函数大全

    2023-12-05 17:32:08       39 阅读
  7. 软件工程 单选多选补充 复刻

    2023-12-05 17:32:08       65 阅读
  8. leetcode 208. 实现 Trie (前缀树)

    2023-12-05 17:32:08       55 阅读
  9. Android 14 CarAudioService

    2023-12-05 17:32:08       53 阅读
  10. Dockerfile 与 Docker Compose区别

    2023-12-05 17:32:08       41 阅读
  11. 分布式和集群区别和优势

    2023-12-05 17:32:08       56 阅读