**1. 實現攔截器SheetWriteHandler** ```java public class CustomSheetWriteHandler implements SheetWriteHandler { @Override public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) { Sheet sheet = writeSheetHolder.getSheet(); //凍結前1列，前1行 sheet.createFreezePane(1, 1); } } ``` **2. 注冊攔截器** ```java @Test public void write01() { Integer num = 0; List<List<Integer>> dataList = Lists.newArrayList(); for (int row = 1; row <= 100; row++) { List<Integer> rowData = Lists.newArrayList(); for (int col = 1; col <= 50; col++) { rowData.add(num++); } dataList.add(rowData); } EasyExcel.write("e:/upload/easyexcel/003.xlsx") .sheet("Sheet1") //注冊攔截器 .registerWriteHandler(new CustomSheetWriteHandler()) .doWrite(dataList); } ```