graph LR
A[Spring Boot] --> B[Controller層]
B --> C[Service層]
C --> D[Entity實(shí)體類]
D --> E[EasyPoi導(dǎo)出引擎]
E --> F[Excel文件]

<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-base</artifactId>
    <version>4.4.0</version>
</dependency>
<dependency>
    <groupId>cn.afterturn</groupId>
    <artifactId>easypoi-web</artifactId>
    <version>4.4.0</version>
</dependency>

# Excel 導(dǎo)出配置
easypoi.export.head-rows=1
easypoi.export.sheet-name=Sheet1

@Data
public class FinancialReport {

    // 一級(jí)表頭：財(cái)務(wù)概覽
    @Excel(name = "財(cái)務(wù)概覽/總收入", orderNum = "0", width = 20)
    private BigDecimal totalIncome;

    // 二級(jí)表頭嵌套
    @Excel(name = "部門(mén)明細(xì)", orderNum = "1")
    private Department department;

    // 集合類型表頭
    @ExcelCollection(name = "項(xiàng)目明細(xì)")
    private List<Project> projects;
}

@Data
public class Department {
    @Excel(name = "部門(mén)名稱", orderNum = "0", width = 15)
    private String deptName;

    @Excel(name = "人員規(guī)模", orderNum = "1", width = 10)
    private Integer staffCount;
}

@Data
public class Project {
    @Excel(name = "項(xiàng)目名稱", orderNum = "0", width = 25)
    private String projectName;

    // 三級(jí)表頭
    @Excel(name = "成本明細(xì)/人力成本", orderNum = "1", width = 15)
    private BigDecimal laborCost;

    @Excel(name = "成本明細(xì)/設(shè)備成本", orderNum = "2", width = 15)
    private BigDecimal equipmentCost;
}

public class ExcelExportUtil {

    public static Workbook createWorkbook(List<FinancialReport> data) {
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("財(cái)務(wù)報(bào)告");

        // 創(chuàng)建表頭行
        Row headerRow = sheet.createRow(0);

        // 動(dòng)態(tài)構(gòu)建多級(jí)表頭
        buildHeaderRow(headerRow, 0, data.getClass().getDeclaredFields());
        
        // 填充數(shù)據(jù)
        int rowNum = 1;
        for (FinancialReport report : data) {
            Row row = sheet.createRow(rowNum++);
            fillDataRow(row, report);
        }

        // 自動(dòng)調(diào)整列寬
        for (int i = 0; i < headerRow.getLastCellNum(); i++) {
            sheet.autoSizeColumn(i);
        }

        return workbook;
    }

    private static void buildHeaderRow(Row row, int level, Field[] fields) {
        for (Field field : fields) {
            Excel excel = field.getAnnotation(Excel.class);
            if (excel != null) {
                Cell cell = row.createCell(excel.orderNum());
                cell.setCellValue(excel.name());
                
                // 處理合并單元格
                if (excel.mergeVertical() || excel.mergeHorizontal()) {
                    sheet.addMergedRegion(new CellRangeAddress(
                        0, 0, 
                        excel.orderNum(), 
                        excel.orderNum() + excel.name().split("/").length - 1
                    ));
                }
                
                // 遞歸處理嵌套表頭
                if (!Collection.class.isAssignableFrom(field.getType())) {
                    buildHeaderRow(row, level + 1, field.getType().getDeclaredFields());
                }
            }
        }
    }

    private static void fillDataRow(Row row, Object obj) {
        Field[] fields = obj.getClass().getDeclaredFields();
        for (Field field : fields) {
            field.setAccessible(true);
            try {
                Cell cell = row.createCell(field.getAnnotation(Excel.class).orderNum());
                cell.setCellValue(field.get(obj).toString());
            } catch (IllegalAccessException e) {
                e.printStackTrace();
            }
        }
    }
}

@RestController
@RequestMapping("/export")
public class ExcelController {

    @Autowired
    private ReportService reportService;

    @GetMapping("/financial-report")
    public void exportFinancialReport(HttpServletResponse response) {
        try {
            // 生成數(shù)據(jù)
            List<FinancialReport> data = reportService.generateReportData();

            // 創(chuàng)建工作簿
            Workbook workbook = ExcelExportUtil.createWorkbook(data);

            // 設(shè)置響應(yīng)頭
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setHeader("Content-Disposition", 
                "attachment;filename=" + URLEncoder.encode("財(cái)務(wù)報(bào)告.xlsx", "UTF-8"));

            // 寫(xiě)入輸出流
            workbook.write(response.getOutputStream());
            workbook.close();
        } catch (Exception e) {
            throw new RuntimeException("導(dǎo)出失敗：" + e.getMessage());
        }
    }
}

# 大數(shù)據(jù)量導(dǎo)出配置
easypoi.export.big-data=true
easypoi.export.row-access-window-size=100

public class DynamicHeaderBuilder {
    
    public static List<ExcelExportEntity> buildDynamicHeader() {
        List<ExcelExportEntity> entities = new ArrayList<>();
        
        // 一級(jí)表頭
        ExcelExportEntity parent = new ExcelExportEntity("財(cái)務(wù)分析", "finance");
        parent.setNeedMerge(true);
        
        // 二級(jí)表頭
        ExcelExportEntity child1 = new ExcelExportEntity("收入分析", "income");
        ExcelExportEntity child2 = new ExcelExportEntity("支出分析", "expense");
        
        // 三級(jí)表頭
        ExcelExportEntity grandChild1 = new ExcelExportEntity("銷售收入", "sales");
        ExcelExportEntity grandChild2 = new ExcelExportEntity("運(yùn)營(yíng)成本", "operating");
        
        // 構(gòu)建層級(jí)關(guān)系
        child1.setList(Arrays.asList(grandChild1));
        child2.setList(Arrays.asList(grandChild2));
        parent.setList(Arrays.asList(child1, child2));
        
        entities.add(parent);
        return entities;
    }
}

public class CustomStyleUtil {
    
    public static CellStyle createHeaderStyle(Workbook workbook) {
        CellStyle style = workbook.createCellStyle();
        Font font = workbook.createFont();
        font.setBold(true);
        font.setColor(IndexedColors.WHITE.getIndex());
        
        style.setFont(font);
        style.setFillForegroundColor(IndexedColors.DARK_BLUE.getIndex());
        style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        style.setAlignment(HorizontalAlignment.CENTER);
        
        return style;
    }
}

TemplateExportParams params = new TemplateExportParams("template.xlsx");
Map<String, Object> data = new HashMap<>();
data.put("title", "財(cái)務(wù)報(bào)告");
data.put("detail", reportData);
Workbook workbook = ExcelExportUtil.exportExcel(params, data);

List<ExcelExportEntity> dynamicColumns = new ArrayList<>();
dynamicColumns.add(new ExcelExportEntity("動(dòng)態(tài)列1", "field1"));
dynamicColumns.add(new ExcelExportEntity("動(dòng)態(tài)列2", "field2"));
ExcelExportUtil.exportBigExcel(params, dynamicColumns, data);