package enumeration.converter; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.GlobalConfiguration; import com.alibaba.excel.metadata.data.ReadCellData; import com.alibaba.excel.metadata.data.WriteCellData; import com.alibaba.excel.metadata.property.ExcelContentProperty; import enumeration.general.AlarmLevelEnum; /** * @author gonghl * @since 2024/8/26 下午 4:00 */ public class AlarmLevelConverter implements Converter { @Override public Class supportJavaTypeKey() { return Converter.super.supportJavaTypeKey(); } @Override public CellDataTypeEnum supportExcelTypeKey() { return Converter.super.supportExcelTypeKey(); } @Override public AlarmLevelEnum convertToJavaData(ReadCellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception { String value = cellData.getStringValue(); if (AlarmLevelEnum.LOW.getDesc().equals(value)) { return AlarmLevelEnum.LOW; } if (AlarmLevelEnum.MIDDLE.getDesc().equals(value)) { return AlarmLevelEnum.MIDDLE; } if (AlarmLevelEnum.HIGH.getDesc().equals(value)) { return AlarmLevelEnum.HIGH; } if (AlarmLevelEnum.VERY_HIGH.getDesc().equals(value)) { return AlarmLevelEnum.VERY_HIGH; } return null; } @Override public WriteCellData convertToExcelData(AlarmLevelEnum value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception { return new WriteCellData<>(value.getDesc()); } }