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 DutyConvert 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 duty=context.getReadCellData().getStringValue(); switch (duty){ case "在岗": return 0; case "退休": return 1; default: return 0; } } }