Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
yangankang opened this issue Apr 6, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@yangankang
Copy link

使用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 yangankang added the bug Something isn't working label Apr 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants