alibaba/easyexcel

可以做到一个页签用模板填充,一个页直接写入吗?

Open

#2,715 创建于 2022年9月13日

在 GitHub 查看
 (1 评论) (0 反应) (0 负责人)Java (7,599 fork)batch import
help wantedpending verification

仓库指标

Star
 (33,728 star)
PR 合并指标
 (30 天内没有已合并 PR)

描述

建议先去看文档 快速开始常见问题 异常代码

     String templateFileName = "E:\\xnworkspace\\mgmt-data-analysis\\src\\main\\resources\\template\\mainReportTpl.xlsx";
        String fileName = "E:\\xnworkspace\\mgmt-data-analysis\\sdf.xlsx";

        MainReportData data = projectService.mainReportData(41);
        List<DetailReportData> mainReportData = projectService.detailReportData(41);
        DetailReportData.replaceStatusField(mainReportData);
        List<OnceAbsoluteMergeStrategy> mergeStrategyList = DetailReportData.getMergeStrategy(mainReportData);
        List<HorizontalCellStyleStrategy> styleStrategyList = DetailReportData.getStyleStrategy(mainReportData);
        ExcelWriterBuilder write = EasyExcel.write(fileName);
        write.withTemplate(templateFileName).sheet().doFill(data);

        ExcelWriterSheetBuilder sheet2 = write.head(DetailReportData.class).sheet(1, "任务详情");
        for (OnceAbsoluteMergeStrategy onceAbsoluteMergeStrategy : mergeStrategyList) {
            sheet2.registerWriteHandler(onceAbsoluteMergeStrategy);
        }
        for (HorizontalCellStyleStrategy horizontalCellStyleStrategy : styleStrategyList) {
            sheet2.registerWriteHandler(horizontalCellStyleStrategy);
        }
        sheet2.doWrite(mainReportData);

异常提示 image image

建议描述 目前的情况是第一个只要加上了第二个页签的处理,第一个页签的数据就是空的

贡献者指南