Cannot get a STRING value from a NUMERIC cell] with root cause
时间: 2023-10-29 07:53:02 浏览: 46
这个错误是由于在Excel数据中,尝试从一个数字类型的单元格读取字符串并写入数据库时引起的。\[1\]解决这个问题的方法是先设置单元格的类型为字符串,然后再读取其值。例如,在Java中可以使用以下代码来解决这个问题:\[2\]首先检查单元格是否为空,然后将其类型设置为字符串,最后获取其字符串值。这样就可以将纯数字作为字符串类型读取进来了。\[3\]
#### 引用[.reference_title]
- *1* *2* [Excel导入异常Cannot get a text value from a numeric cell解决](https://blog.csdn.net/xiaoqiangyonghu/article/details/84571462)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [Cannot get a text value from a numeric cell](https://blog.csdn.net/xiaozhuangyumaotao/article/details/113177755)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]