EasyExcel多行复杂表头（所有表头可全部自定义）

王翼鹏

已于 2024-07-10 12:45:14 修改

阅读量423

点赞数

分类专栏： java 文章标签： easyexcel 表头

于 2024-04-26 19:21:35 首次发布

原文链接：https://blog.csdn.net/weixin_55585048/article/details/136474486

版权

java 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

// 因为我要动态获取日期dateList是日期
EasyExcelUtils.writeExcel(response, 
                fileName, sheetName, head(dateList), fillData(dateList, bedsInfos));

    private List<List<String>> head(List<LocalDate> dateList) {
        List<List<String>> headTitles = Lists.newArrayList();
        // 固定title
        String billPeriodHead = "自定义日期区间";
        headTitles.add(Lists.newArrayList(billPeriodHead, "序号", "序号"));
        headTitles.add(Lists.newArrayList(billPeriodHead, "船号", "船号"));
        headTitles.add(Lists.newArrayList(billPeriodHead, "持证人", "持证人"));
        List<String> paymentTitles = Lists.newArrayList("上午", "下午");
        for (LocalDate localDate : dateList) {
            for (String paymentTitle : paymentTitles) {
                headTitles.add(Lists.newArrayList(billPeriodHead, String.valueOf(localDate.getDayOfMonth()) + "日",
                        paymentTitle));
            }
        }
        return headTitles;
    }

效果