Cannot get a numeric value from a text cell 该如何解决?description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException:java.lang.IllegalStateException:Cannot get a n
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/27 00:28:38
Cannot get a numeric value from a text cell 该如何解决?description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException:java.lang.IllegalStateException:Cannot get a n
Cannot get a numeric value from a text cell 该如何解决?
description
The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException:java.lang.IllegalStateException:Cannot get a numeric value from a text cell
在导入EXCEL时候提示此报错信息;看到你回答了一个类似的,希望能得到错误翻译,并且给予解决方案.
Cannot get a numeric value from a text cell 该如何解决?description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException:java.lang.IllegalStateException:Cannot get a n
Excel数据Cell有不同的类型,当读取数据并写入数据库时,如果数据类型不匹配,就会报出相关异常.
你的这个异常就是不能将单元格的类型转换成numberic,所以需要你人工处理
row.getCell(0).setCellType(CELL_TYPE_NUMERIC); //将数据类型设置为numberic
然后再去读取相应的值就可以了.