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"
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix