設置列寬可以有如下幾種方式。 [TOC] # 1. @ColumnWidth設置 ```java @Data @AllArgsConstructor public class Dog { @ColumnWidth(25) @ExcelProperty("名字") private String name; @ColumnWidth(50) @ExcelProperty("年齡") private Integer age; } ``` # 2. 攔截器設置 **1. 繼承AbstractColumnWidthStyleStrategy** ```java public class ColumnWidthStyleHandler extends AbstractColumnWidthStyleStrategy { /** * 每寫入一列就被調用一次 */ @Override public void setColumnWidth(WriteSheetHolder writeSheetHolder, List<WriteCellData<?>> cellDataList , Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) { Sheet sheet = writeSheetHolder.getSheet(); //void setColumnWidth(int var1, int var2) //var1：單元格索引 //var2：單元格寬度 sheet.setColumnWidth(cell.getColumnIndex(), 6000); } } ``` **2. 注冊攔截器** ```java @Test public void write02() { String path = "e:/upload/easyexcel/006.xlsx"; List<Cat> catList = Lists.newArrayList(); Cat cat01 = new Cat("小貓", 25); Cat cat02 = new Cat("橘貓", 30); catList.add(cat01); catList.add(cat02); EasyExcel.write(path, Cat.class) //注冊攔截器 .registerWriteHandler(new ColumnWidthStyleHandler()) .sheet("cat1").doWrite(catList); } ```