1、先将小数转化为字符串 2、从最后一位未0开始计数到小数点的位数就是小数的位数
public CellDataTypeEnum supportExcelTypeKey() { return CellDataTypeEnum.NUMBER; } public BigDecimal convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) { return cellData.getNumberValue(); } public CellData convertToExcelData(BigDecimal value, ExcelCo...
=ROUND(RAND()*(1.5-(-1.5))+(-1.5),1)