Exception in thread "main" org.apache.poi.ss.formula.FormulaParseException: Parse error near char 0 '★' in specified formula '★★Sheet1!B54'. Expected cell ref or constant literal
at org.apache.poi.ss.formula.FormulaParser.expected(FormulaParser.java:269)
at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1545)
at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1498)
at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1485)
at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1858)
at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1986)
at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1970)
at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1927)
at org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1900)
at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1880)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2028)
at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:170)
at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:85)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:276)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:220)
at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:64)
at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(BaseFormulaEvaluator.java:192)
at readExcel.CopyExcelTbl.refreshFormula(CopyExcelTbl.java:120)
at readExcel.CopyExcelTbl.copyTblByCoordinate(CopyExcelTbl.java:74)
at readExcel.CopyExcelTbl.main(CopyExcelTbl.java:183)
想要一个单元格的公式,公式是取另一个sheet的单元格值,
另一个sheet名字中有特殊字符“★”,
报错信息如上,求解决之道
![](https://profile-avatar.csdnimg.cn/da319eb333fb4b0282669ba06cf242f4_the01.jpg!4)
poi刷新excel公式的问题
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
2条回答 默认 最新
悬赏问题
- ¥15 metadata提取的PDF元数据,如何转换为一个Excel
- ¥15 关于arduino编程toCharArray()函数的使用
- ¥100 vc++混合CEF采用CLR方式编译报错
- ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误,如何解决?
- ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
- ¥15 c#逐行读取txt文本,但是每一行里面数据之间空格数量不同
- ¥50 如何openEuler 22.03上安装配置drbd
- ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
- ¥15 无线连接树莓派,无法执行update,如何解决?(相关搜索:软件下载)
- ¥15 Windows11, backspace, enter, space键失灵