SpringBoot使用EasyExcel将Excel数据直接转换为类对象

/**
 * 使用Class来读取Excel
 *
 * @param inputStream   Excel的输入流
 * @param excelTypeEnum Excel的格式(XLS或XLSX)
 * @return 返回 ClassList 的列表
 */
public static <T> List<T> readExcelConvertObjectList(InputStream inputStream, ExcelTypeEnum excelTypeEnum, Class<T> classT) {
    return readExcelWithClassList(inputStream, excelTypeEnum, 1, classT);
}
/**
 * 读取excel数据到数据对象
 *
 * @param inputStream 文件流
 * @param excelTypeEnum 文件类型Excel的格式(XLS或XLSX)
 * @param headLineNum 开始读取数据的行
 * @param classT 转为对象的CLASS
 * @param <T>
 * @return
 */
public static <T> List<T> readExcelConvertObjectList(InputStream inputStream, ExcelTypeEnum excelTypeEnum,
                                                 @Nullable Integer headLineNum, Class<T> classT) {
    if (headLineNum == null) {
        headLineNum = 1;
    }
    return EasyExcel.read(inputStream).excelType(excelTypeEnum)
            .registerConverter(new StringConverter())
            .head(classT)
            .sheet()
            .headRowNumber(headLineNum)
            .doReadSync();
}

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;
 
public class StringConverter implements Converter<String> {
 
    @Override
    public Class supportJavaTypeKey() {
        return String.class;
    }
 
    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }
 
    /**
     * 将excel对象转成Java对象，这里读的时候会调用
     *
     * @param cellData            NotNull
     * @param contentProperty     Nullable
     * @param globalConfiguration NotNull
     * @return
     */
    @Override
    public String convertToJavaData(CellData cellData, ExcelContentProperty contentProperty,
                                    GlobalConfiguration globalConfiguration) {
        return cellData.getStringValue();
    }
 
    /**
     * 将Java对象转成String对象，写出的时候调用
     *
     * @param value
     * @param contentProperty
     * @param globalConfiguration
     * @return
     */
    @Override
    public CellData convertToExcelData(String value, ExcelContentProperty contentProperty,
                                       GlobalConfiguration globalConfiguration) {
        return new CellData(value);
    }
}

@Data
public class BankInfoImportExcelDto {
 
    @ExcelProperty(index = 0,value = "银行ID")
    @Min(value = 1 message = "ID不能小于1")
    private Long bankId;
 
    @ExcelProperty(index = 1,value = "银行名称")
    @NotBlank
    private String bankName;
 
    @ExcelProperty(index = 2,value = "银行地址")
    private String address;
 
}

@PostMapping("/import")
    public ResultT importExcel(@RequestParam("file") MultipartFile file) throws IOException {
      
        InputStream inputStream = file.getInputStream();
        List<BankInfoImportExcelDto> importBankInfoExcelDtoList = readExcelConvertObjectList(inputStream,ExcelTypeEnum.XLSX,BankInfoImportExcelDto.class);

......
    }