java Cannot get a STRING value from a NUMERIC cell 错误

一、Cannot get a STRING value from a NUMERIC cell 错误是什么?

使用Apache-POI读取excel文件时,如果获取数据的方法与实际类型不符,会抛出IllegalStateException错误,如下:
java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1075)
at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:396)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:348)
at com.fr.function.POIExcel.createDownload(POIExcel.java:95)
at com.fr.function.POIExcel.run(POIExcel.java:30)
at com.fr.script.AbstractFunction.evalExpression(Unknown Source)
at com.fr.parser.FunctionCall.eval(Unknown Source)
at com.fr.script.Calculator.eval(Unknown Source)
at com.fr.stable.script.Expression.eval(Unknown Source)
at com.fr.script.Calculator.evalString(Unknown Source)
at com.fr.script.Calculator.eval(Unknown Source)
at com.fr.script.Calculator.evalValue(Unknown Source)
at com.fr.stable.AbstractFormulaProvider.evalValue(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.dealWithBENormal(Unknown Source)
at com.fr.report.core.A.m.cc_ce_array(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.A(Unknown Source)
at com.fr.report.core.A.J.C(Unknown Source)
at com.fr.report.core.A.J.execute4Expand(Unknown Source)
at com.fr.report.core.A.J.execute(Unknown Source)
at com.fr.report.worksheet.WorkSheet.execute(Unknown Source)
at com.fr.report.core.sheet.AbstractWorkBookExecutor._execute(Unknown Source)
at com.fr.report.core.sheet.AbstractWorkBookExecutor.execute(Unknown Source)
at com.fr.main.impl.WorkBook.execute(Unknown Source)
at com.fr.main.impl.WorkBook.execute(Unknown Source)
at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source)
at com.fr.stable.PageActor.getResultBookFromCacheIfNeed(Unknown Source)
at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.execute(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.computeBook2Show o r

本文来自网络,不代表协通编程立场,如若转载,请注明出处:https://net2asp.com/31ba83fa33.html