easyexcel doRead bug

复制代码

public class CarOilingRecordImportVO {
/**
* 油卡号
*/
@ExcelProperty(value = "卡号/客户编号")
@NotNull(message = "卡号/客户编号不能为空")
private String cardCode;

/**
* 车牌号
*/
@ExcelProperty(value = "车辆牌照")
private String carCode;

/**
* 交易日期
*/
@NotNull(message = "交易时间不能为空")
@ExcelProperty(value = "交易时间")
private Date dealDate;

/**
* 金额
*/
@ExcelProperty(value = "金额(元)")
@NotNull(message = "金额(元)不能为空")
private BigDecimal sumMoney;

/**
* 油品
*/
@ExcelProperty(value = "商品种类")
@NotNull(message = "商品种类不能为空")
private String oils;

/**
* 数量
*/
@ExcelProperty(value = "油量(升)")
@NotNull(message = "油量(升)不能为空")
private Double quantity;

/**
* 地点
*/
@ExcelProperty(value = "受理机构")
private String location;

/**
* 交易流水号
*/
@ExcelProperty(value = "交易流水号")
@NotNull(message = "交易流水号不能为空")
private String tradeSerialNum;

/**
* 交易类型
*/
@ExcelProperty(value = "交易类型")
@NotNull(message = "交易类型不能为空")
private String tradeType;

/**
* 交易状态
*/
@ExcelProperty(value = "交易状态")
@NotNull(message = "交易状态不能为空")
private String tradeStatus;

/**
* 折扣
*/
@ExcelProperty(value = "折扣(元)")
@NotNull(message = "折扣不能为空")
private BigDecimal discount;

/**
* 来源类型
*/
private Integer sourceType;
}
 
复制代码

 

 

sourceType没有@ExcelProperty 导致值赋字段错乱

复制代码
private static Object doConvertToJavaObject(ReadCellData<?> cellData, Class<?> clazz,
        ExcelContentProperty contentProperty, Map<ConverterKey, Converter<?>> converterMap, AnalysisContext context,
        Integer rowIndex, Integer columnIndex) {
        Converter<?> converter = null;
        if (contentProperty != null) {
            converter = contentProperty.getConverter();
        }

        boolean canNotConverterEmpty = cellData.getType() == CellDataTypeEnum.EMPTY
            && !(converter instanceof NullableObjectConverter);
        if (canNotConverterEmpty) {
            return null;
        }

        if (converter == null) {
            converter = converterMap.get(ConverterKeyBuild.buildKey(clazz, cellData.getType()));
        }
        if (converter == null) {
            throw new ExcelDataConvertException(rowIndex, columnIndex, cellData, contentProperty,
                "Converter not found, convert " + cellData.getType() + " to " + clazz.getName());
        }

        try {
            return converter.convertToJavaData(new ReadConverterContext<>(cellData, contentProperty, context));
        } catch (Exception e) {
            throw new ExcelDataConvertException(rowIndex, columnIndex, cellData, contentProperty,
                "Convert data " + cellData + " to " + clazz + " error ", e);
        }java.lang.NumberFormatException: For input string: "2024-08-22"
复制代码

 

posted @   八英里  阅读(5)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
点击右上角即可分享
微信分享提示