easyexcel注解样式无效_Easyexcel自定义格式-头部样式

1 /**

2 * 自定义excel头部样式拦截器3 *@authorchenkun4 * @desc5 * @datetime 2020/9/30 14:336 */

7

8 public class StyleExcelHandler implementsSheetWriteHandler {9

10 @Override11 public voidbeforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {12

13 }14

15 @Override16 public voidafterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {17

18 Class clazz =writeSheetHolder.getClazz();19 ExcelHeadStyle annotation = (ExcelHeadStyle) clazz.getAnnotation(ExcelHeadStyle.class);20 if (annotation != null) {21 switch(annotation.type()) {22 caseBASE:23 doBase(writeWorkbookHolder, annotation);24 break;25 caseEXCEL_DSMD:26 doInstructor(writeWorkbookHolder, annotation);27 break;28 default:29 //doAnything

30 break;31 }32 }33

34 }35

36 private voiddoInstructor(WriteWorkbookHolder writ