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.AlarmCategoryEnum; /** * @author gonghl * @since 2024/8/26 下午 4:00 */ public class AlarmCategoryConverter implements Converter { @Override public Class supportJavaTypeKey() { return Converter.super.supportJavaTypeKey(); } @Override public CellDataTypeEnum supportExcelTypeKey() { return Converter.super.supportExcelTypeKey(); } @Override public AlarmCategoryEnum convertToJavaData(ReadCellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { String value = cellData.getStringValue(); if (AlarmCategoryEnum.SSH.getDesc().equals(value)) { return AlarmCategoryEnum.SSH; } if (AlarmCategoryEnum.TELNET.getDesc().equals(value)) { return AlarmCategoryEnum.TELNET; } if (AlarmCategoryEnum.RDP.getDesc().equals(value)) { return AlarmCategoryEnum.RDP; } if (AlarmCategoryEnum.FTP.getDesc().equals(value)) { return AlarmCategoryEnum.FTP; } if (AlarmCategoryEnum.DATABASE.getDesc().equals(value)) { return AlarmCategoryEnum.DATABASE; } return null; } @Override public WriteCellData convertToExcelData(AlarmCategoryEnum value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { return new WriteCellData<>(value.getDesc()); } }