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("男");
}
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)