easyexcel 读取会计格式的单元格数据,无法解析欧元货币符号: €
报错如下:
java.lang.IllegalArgumentException:Unquotedspecialcharacter';'inpattern"€#,##0.00;€(#,##0.00);€-??"
2023-02-22 09:19:51.534 [main] WARN org.apache.poi.ss.format.CellFormatter - Invalid format: "([$€-2]* #,##0.00);"
java.lang.IllegalArgumentException: Unsupported [] format block '[' in '([$€-2]* #,##0.00)' with c2: null
at org.apache.poi.ss.format.CellFormatPart.formatType(CellFormatPart.java:373)
at org.apache.poi.ss.format.CellFormatPart.getCellFormatType(CellFormatPart.java:287)
at org.apache.poi.ss.format.CellFormatPart.(CellFormatPart.java:191)
at org.apache.poi.ss.format.CellFormat.(CellFormat.java:189)
at org.apache.poi.ss.format.CellFormat.getInstance(CellFormat.java:163)
at com.alibaba.excel.metadata.format.DataFormatter.getFormat(DataFormatter.java:212)
at com.alibaba.excel.metadata.format.DataFormatter.getFormattedNumberString(DataFormatter.java:648)
at com.alibaba.excel.metadata.format.DataFormatter.format(DataFormatter.java:664)
at com.alibaba.excel.util.NumberDataFormatterUtils.format(NumberDataFormatterUtils.java:57)
at com.alibaba.excel.util.NumberDataFormatterUtils.format(NumberDataFormatterUtils.java:35)
at com.alibaba.excel.converters.string.StringNumberConverter.convertToJavaData(StringNumberConverter.java:54)
at com.alibaba.excel.converters.string.StringNumberConverter.convertToJavaData(StringNumberConverter.java:23)
at com.alibaba.excel.converters.Converter.convertToJavaData(Converter.java:57)
at com.alibaba.excel.util.ConverterUtils.doConvertToJavaObject(ConverterUtils.java:153)
at com.alibaba.excel.util.ConverterUtils.convertToJavaObject(ConverterUtils.java:100)
at com.alibaba.excel.read.listener.ModelBuildEventListener.buildUserModel(ModelBuildEventListener.java:103)
at com.alibaba.excel.read.listener.ModelBuildEventListener.invoke(ModelBuildEventListener.java:41)
at com.alibaba.excel.read.listener.ModelBuildEventListener.invoke(ModelBuildEventListener.java:26)
at com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor.dealData(DefaultAnalysisEventProcessor.java:99)
at com.alibaba.excel.read.processor.DefaultAnalysisEventProcessor.endRow(DefaultAnalysisEventProcessor.java:46)
at com.alibaba.excel.analysis.v07.handlers.RowTagHandler.endElement(RowTagHandler.java:66)
at com.alibaba.excel.analysis.v07.handlers.sax.XlsxRowHandler.endElement(XlsxRowHandler.java:91)