package com.gkhy.assess.common.excel; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.converters.ReadConverterContext; import com.alibaba.excel.enums.CellDataTypeEnum; public class SexConvert implements Converter { @Override public Class supportJavaTypeKey() { return Integer.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public Integer convertToJavaData(ReadConverterContext context) throws Exception { String sex=context.getReadCellData().getStringValue(); switch (sex){ case "男": return 0; case "女": return 1; default: return 2; } } }