最近项目有个读取EXCEL文件内容的需求.于是找了资料写了如下代码
POIFSFileSystem fs = null;
HSSFWorkbook wb = null;
try {
fs = new POIFSFileSystem(new FileInputStream("d:\test.xls"));
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
e.printStackTrace();
}
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short) 0);
String msg = cell.getStringCellValue(); //报错行结果在页面中报错
java.lang.NumberFormatException: You cannot get a string value from a numeric cell
org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:775)
com.etech.tutiya.business.UploadFile2.doInit(UploadFile2.java:77)
com.etech.tutiya.action.UploadFile2Action.init(UploadFile2Action.java:44)发生错误的就是上面的报错行.请问大家这是什么问题,谢谢
POIFSFileSystem fs = null;
HSSFWorkbook wb = null;
try {
fs = new POIFSFileSystem(new FileInputStream("d:\test.xls"));
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
e.printStackTrace();
}
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short) 0);
String msg = cell.getStringCellValue(); //报错行结果在页面中报错
java.lang.NumberFormatException: You cannot get a string value from a numeric cell
org.apache.poi.hssf.usermodel.HSSFCell.getStringCellValue(HSSFCell.java:775)
com.etech.tutiya.business.UploadFile2.doInit(UploadFile2.java:77)
com.etech.tutiya.action.UploadFile2Action.init(UploadFile2Action.java:44)发生错误的就是上面的报错行.请问大家这是什么问题,谢谢
在用getXXX方法去区
试试看
说得很明白了,数据类型不匹配。