easyExcel导入时处理自定义的转换converter，Boolean由true和false转成Y和N

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.alibaba.excel.util.StringUtils;
import com.alibaba.excel.converters.Converter;
public class BooleanToYNConverter implements Converter<Boolean> {

	@Override
	public Class<Boolean> supportJavaTypeKey() {
		return Boolean.class;
	}

	@Override
	public CellDataTypeEnum supportExcelTypeKey() {
		return null;
	}

	@Override
	public Boolean convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
		if (cellData == null){
			return null;
		}
		// 导入时，"Y"转为true，"N"转为false
		String cellValue = cellData.getStringValue();
		return "Y".equals(cellValue);
	}

	@Override
	public CellData convertToExcelData(Boolean aBoolean, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
		// 导出时，转换Boolean为"Y"或"N"
		return new CellData(aBoolean != null && aBoolean ? "Y" : "N");
	}

}

	/**
	 * 密封面清洁/无缺陷
	 */
	@ColumnWidth(50)
	@ExcelProperty(value = {"Flange Inspection Items","Flange Inspection Items","Sealing Face Condition Clean Free From Defects"},converter = BooleanToYNConverter.class)
	private Boolean sealingFaceConditionCleanFreeFromDefects;

	/**
	 * 密封面法兰对其
	 */
	@ColumnWidth(50)
	@ExcelProperty(value = {"Flange Inspection Items","Flange Inspection Items","Sealing Face Condition Flange Aligned"},converter = BooleanToYNConverter.class)
	private Boolean sealingFaceConditionFlangeAligned;

把这个converter放在注解里就行