alibaba/easyexcel

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

Open

#2,715 opened on Sep 13, 2022

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Java (7,599 forks)batch import
help wantedpending verification

Repository metrics

Stars
 (33,728 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

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

     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

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

Contributor guide

Research direction
Examine the interaction between EasyExcel's withTemplate() and head() methods when writing multiple sheets. The issue suggests that using withTemplate() on the writer and then adding a second sheet with head() causes the template filled sheet to become empty. Investigate if the ExcelWriter instance is being reused correctly, and if template filling should be done on a separate writer or after the head based sheet. Check EasyExcel's source code or documentation for proper usage patterns for mixing template and head based sheets.
Tech stack
java
Domain
backend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
JavaEasyExcel
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60