You cannot get a string value from a numeric cell

最新推荐文章于 2025-06-06 16:05:58 发布

regedit123

最新推荐文章于 2025-06-06 16:05:58 发布

阅读量831

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/regedit123/article/details/83529592

本文介绍了一种在Java中从Excel文件读取数据并将其插入数据库的方法，特别关注了解决'You cannot get a string value from a numeric cell'错误的过程。通过使用正确的类型转换，确保了数值单元格的数据能正确转换为字符串。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

You cannot get a string value from a numeric cell　问题报错提示。

解决办法请见下面红色字体内容！
在读取excle表格存入数据库时候出现了这个问题package db;

import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.model.Sheet;
import org.apache.poi.hssf.model.Workbook;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Excel {
public static DbConn DB = new DbConn();
public static void main(String[] args) throws Exception {
int num = 5;
int i = 0;
int b = 0;
int j = 0;
try {
Connection con = DB.getConnection();
String sql = "insert into b(v_area_name,v_phonenum,v_month) values(?,?,?)";
PreparedStatement pre = null;
pre = con.prepareStatement(sql);
List list = new ArrayList();
InputStream in = new FileInputStream("d:/c.xls");
HSSFWorkbook jlw = new HSSFWorkbook(in);
HSSFSheet sh = jlw.getSheetAt(1);
if (sh == null) {
in.close();
} else {
int number = sh.getPhysicalNumberOfRows();
if (number < 1) {
in.close();
} else {
HSSFRow row = null;
try{
while (i < number) {
for(;i<number;i++){
row = sh.getRow(i);
pre.setString(1, row.getCell((short)0).getStringCellValue());
pre.setString(2, String.valueOf((long)row.getCell((short)1).getNumericCellValue()));//这样就可以解决了，如果数据比较小，用int也行
pre.setString(3,"200909");
pre.addBatch();
j++;
if (j % num == 0) {
pre.executeBatch();
pre.clearParameters();
pre.clearBatch();
b = number - j;
}
}
}
}catch(Exception e){
e.printStackTrace();
}
if (b < num) {
System.out.println(b);
pre.executeBatch();
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}