easyexcel icon indicating copy to clipboard operation
easyexcel copied to clipboard

解析Excel单元格格式报错,DataFormatter - Formatting failed for format 0"."0,"万元", falling back

Open yangankang opened this issue 2 years ago • 0 comments

使用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版本

yangankang avatar Apr 06 '24 03:04 yangankang