EasyExcel 不僅提供了一些簡單使用的功能，還提供了寫攔截器，當這些簡單的功能不滿足要求時，便可以調用攔截器來完成。 ```java /** 共有 4 種類型攔截器，每種攔截器都有很多的抽象實現類 */ public interface CellWriteHandler extends WriteHandler { ... } public interface RowWriteHandler extends WriteHandler { ... } public interface SheetWriteHandler extends WriteHandler { ... } public interface WorkbookWriteHandler extends WriteHandler { ... } ``` 下面通過使用 SheetWriteHandler 攔截器實現凍結表頭來講解攔截器的使用步驟，其它的都是一樣的道理。 **1. 實現攔截器接口** ```java public class CustomSheetWriteHandler implements SheetWriteHandler { @Override public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) { Sheet sheet = writeSheetHolder.getSheet(); //凍結前0列，前1行 sheet.createFreezePane(0, 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); } ```