public class SexConverter implements Converter{ //在java中性别是用 0 1 来标识的 所以是int @Override public Class supportJavaTypeKey() {return Integer.class;} // 在excel中是男女 所以是string @Override public CellDataTypeEnum supportExcelTypeKey() {return CellDataTypeEnum.STRING;} //将excel的数据类型转为java数据类型 @Override public Integer convertToJavaData(ReadCellData readCellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { String stringValue = readCellData.getStringValue(); if (stringValue == null) { throw new RuntimeException("性别填写为空"); } if ("男".equals(stringValue)) { return 1; } return 0; } //将java的数据类型转为excel数据类型 @Override public WriteCellData convertToExcelData(Integer s, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { if (s == 0){ return new WriteCellData("女"); } return new WriteCellData("男"); } }



