Convert data:xxx return null, at row:1

工具：

alibaba.excel

WriteCellData writeCellData = new WriteCellData();
writeCellData.setNumberValue(new BigDecimal("1"));

结果：报错

 return new WriteCellData<>(BigDecimal.valueOf(Double.valueOf(value)));

结果：正常

根据源码可知 在实例化对象赋值后 需要指定Type

 

 

C

onvert data:100.00 return null, at row:1