package com.zzg.system.convert.easyExcel; import com.alibaba.excel.converters.Converter; import com.alibaba.excel.converters.ReadConverterContext; import com.alibaba.excel.converters.WriteConverterContext; import com.alibaba.excel.enums.CellDataTypeEnum; import com.alibaba.excel.metadata.data.WriteCellData; import com.zzg.common.utils.StringUtils; import java.util.Objects; public class StringConverter implements Converter { @Override public Class supportJavaTypeKey() { return String.class; } @Override public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.STRING; } /** * 这里读的时候会调用 * * @param context * @return */ @Override public String convertToJavaData(ReadConverterContext context) { if (StringUtils.isNotBlank(context.getReadCellData().getStringValue())) { return String.valueOf(context.getReadCellData().getStringValue()); } else if (Objects.nonNull(context.getReadCellData().getNumberValue())) { return String.valueOf(context.getReadCellData().getNumberValue()); } return ""; } /** * 这里是写的时候会调用 不用管 * * @return */ @Override public WriteCellData convertToExcelData(WriteConverterContext context) { return new WriteCellData<>(String.valueOf(context.getValue())); } }