Java使用esayExcel如何在导出模板数据的同时，冻结指定的列数据

可以使用 EasyExcel 的 FreezePane 方法来冻结指定列数据。

首先，在定义 ExcelWriter 对象时，需要指定 sheet 和列的索引，例如：

ExcelWriter writer = EasyExcel.write(fileName).withTemplate(templateName)
                .registerWriteHandler(new FreezePaneWriteHandler(1, 0))
                .build();

其中，`FreezePaneWriteHandler` 是自定义的写入处理器，用于冻结指定列，其中参数 1 表示列索引，0 表示行索引，即冻结第一列。

然后，在写入数据时，需要使用 `Sheet` 对象的 freezePane 方法来冻结列，例如：

Sheet sheet = writer.getSheet();
sheet.freezePane(1, 1);
writer.write(data, sheet);

其中，`freezePane(1, 1)` 方法用于冻结第一行和第一列，即固定表头和第一列数据。

完整代码示例：

public void exportExcel() {
    String fileName = "template.xlsx";
    String templateName = "template.xlsx";
    List<ExportData> data = getData();
    ExcelWriter writer = EasyExcel.write(fileName).withTemplate(templateName)
                    .registerWriteHandler(new FreezePaneWriteHandler(1, 0))
                    .build();
    Sheet sheet = writer.getSheet();
    sheet.freezePane(1, 1);
    writer.write(data, sheet);
    writer.finish();
}

public static class FreezePaneWriteHandler implements WriteHandler {

    private int colSplit;

    private int rowSplit;

    public FreezePaneWriteHandler(int colSplit, int rowSplit) {
        this.colSplit = colSplit;
        this.rowSplit = rowSplit;
    }

    @Override
    public void beforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
        writeSheetHolder.getSheet().createFreezePane(colSplit, rowSplit);
    }

    @Override
    public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
    }

    @Override
    public void afterRowCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder, WriteRowHolder writeRowHolder) {
    }

    @Override
    public void afterCellCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder, WriteRowHolder writeRowHolder, WriteCellHolder writeCellHolder) {
    }

    @Override
    public void afterCellDispose(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder, List<WriteRowHolder> list, WriteCellHolder writeCellHolder, CellData cellData, CellStyle cellStyle) {
    }
}

public static class ExportData {

    @ExcelProperty("姓名")
    private String name;

    @ExcelProperty("年龄")
    private Integer age;

    // getter/setter
}

private List<ExportData> getData() {
    List<ExportData> list = new ArrayList<>();
    list.add(new ExportData("张三", 18));
    list.add(new ExportData("李四", 20));
    return list;
}