easyexcel
easyexcel copied to clipboard
解析Excel单元格格式报错,DataFormatter - Formatting failed for format 0"."0,"万元", falling back
使用wps编辑Excel,设置单元格格式,特殊 -> 单位:万元 -> 万元
try (InputStream is = new FileInputStream(this.file);) { EasyExcel.read(is, new AnalysisEventListener<Map<Integer, Object>>() { ... }).sheet(sheetName).headRowNumber(headRow).doRead(); }
正常读取然后会报错:
ERROR com.alibaba.excel.metadata.format.DataFormatter - Formatting failed for format 0"."0,"万元", falling back java.lang.IllegalArgumentException: Malformed pattern "0.0,万元"
使用的是MacOS12.7.4 Intel CPU ,JDK17版本