<dependencies>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>3.3.2</version>
    </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.24</version>
        <optional>true</optional>
    </dependency>
</dependencies>

@Data
public class Person {
    @ExcelProperty("ID")
    private Integer id;
    
    @ExcelProperty("姓名")
    private String name;
    
    @ExcelProperty("年齡")
    private Integer age;
    
    @ExcelProperty("入職日期")
    private Date joinDate;
}

@Data
public class Department {
    @ExcelProperty("部門ID")
    private Integer deptId;
    
    @ExcelProperty("部門名稱")
    private String deptName;
    
    @ExcelProperty("預(yù)算(萬元)")
    private Double budget;
}

@Service
public class ComplexExcelService {
    
    public void writeComplexTable() {
    
        /*
         //1.寫入io流
        ByteArrayOutputStream outputStream =new ByteArrayOutputStream(1024);
        ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
		*/
		//2。寫入文件
		String fileName = "企業(yè)數(shù)據(jù)報(bào)表_" + LocalDate.now().format(DateTimeFormatter.BASIC_ISO_DATE) + ".xlsx"; 
        try (ExcelWriter excelWriter = EasyExcel.write(fileName).build()) {
            // 創(chuàng)建 WriteSheet，禁用默認(rèn)表頭
            //.registerWriteHandler(XXXHandler)  （XXXHandler需實(shí)現(xiàn) CellWriteHandler）
            WriteSheet writeSheet = EasyExcel.writerSheet("企業(yè)綜合數(shù)據(jù)")
                .needHead(Boolean.FALSE)
                .build();
            
            // 創(chuàng)建第一個表格：人員信息
            WriteTable personnelTable = EasyExcel.writerTable(0)
                .head(Person.class) // 使用類注解生成表頭
                .needHead(Boolean.TRUE)
                .build(); // 可添加 .tableStyle() 自定義樣式
            
            // 創(chuàng)建第二個表格：部門信息，定位在第一個表格下方
            WriteTable departmentTable = EasyExcel.writerTable(1)
                .head(Department.class)
                .needHead(Boolean.TRUE)
                .relativeHeadRowIndex(6) // 預(yù)留空間，避免重疊
                .build();
            
            // 寫入數(shù)據(jù)
            excelWriter.write(generatePersonData(), writeSheet, personnelTable);
            excelWriter.write(generateDepartmentData(), writeSheet, departmentTable);
            
            logger.info("復(fù)雜表格生成完成：{}", fileName);
        }
    }
    
    private List<Person> generatePersonData() {
        // 生成模擬數(shù)據(jù)，略
    }
    
    private List<Department> generateDepartmentData() {
        // 生成模擬數(shù)據(jù)，略
    }
}

@Data
@HeadRowHeight(25)
@ContentRowHeight(20)
public class ComplexHeaderData {
    
    @ExcelProperty(value = {"企業(yè)信息", "基本信息", "員工編號"})
    private String employeeId;
    
    @ExcelProperty(value = {"企業(yè)信息", "基本信息", "姓名"})
    private String name;
    
    @ExcelProperty(value = {"財(cái)務(wù)數(shù)據(jù)", "薪資信息", "基本工資"})
    private Double baseSalary;
    
    @ExcelProperty(value = {"財(cái)務(wù)數(shù)據(jù)", "薪資信息", "績效獎金"})
    private Double performanceBonus;
    
    @ExcelProperty(value = {"財(cái)務(wù)數(shù)據(jù)", "薪資信息", "年終獎"})
    private Double annualBonus;
}

@Component
public class CustomExcelStyleStrategy implements WriteHandler {
    
    @Override
    public void afterCellCreate(WriteSheetHolder writeSheetHolder, 
                               WriteTableHolder writeTableHolder, Cell cell, Head head, 
                               Integer relativeRowIndex, Boolean isHead) {
        
        Workbook workbook = writeSheetHolder.getSheet().getWorkbook();
        CellStyle style = workbook.createCellStyle();
        
        if (isHead) {
            // 表頭樣式：藍(lán)色背景，白色文字
            style.setFillForegroundColor(IndexedColors.ROYAL_BLUE.getIndex());
            style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
            
            Font font = workbook.createFont();
            font.setColor(IndexedColors.WHITE.getIndex());
            font.setBold(true);
            style.setFont(font);
            
            // 邊框設(shè)置
            style.setBorderBottom(BorderStyle.THIN);
            style.setBorderLeft(BorderStyle.THIN);
            style.setBorderRight(BorderStyle.THIN);
            style.setBorderTop(BorderStyle.THIN);
        } else {
            // 數(shù)據(jù)行樣式：灰色邊框
            style.setBorderBottom(BorderStyle.THIN);
            style.setBorderLeft(BorderStyle.THIN);
            style.setBorderRight(BorderStyle.THIN);
            style.setBorderTop(BorderStyle.THIN);
        }
        
        cell.setCellStyle(style);
    }
}

WriteTable personnelTable = EasyExcel.writerTable(0)
    .head(Person.class)
    .needHead(Boolean.TRUE)
    .registerWriteHandler(new CustomExcelStyleStrategy()) // 注冊自定義樣式
    .build();