package com.chinaztt.mes.common.util.easyexcel.converter; import com.alibaba.excel.converters.Converter; 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 org.springframework.stereotype.Component; /** 订单状态转换 * @Author: Zou, Yu * @DATE: 2023/9/24 0024 14:21 */ @Component public class SaleTypeConverter implements Converter { @Override public Class supportJavaTypeKey() { return String.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } @Override public String convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { if("通过".equals(cellData.getStringValue())){ return "1"; }else if("不通过".equals(cellData.getStringValue())){ return "0"; }else{ return "2"; } } @Override public CellData convertToExcelData(String str, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception { if("1".equals(str)){ return new CellData<>("通过"); }else if("0".equals(str)){ return new CellData<>("不通过"); }else{ return new CellData<>("未审核"); } } }