Cannot get a STRING value from a NUMERIC cell

[18916204759]

java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:1077)
at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:395)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:347)
at com.xuxueli.poi.excel.ExcelImportUtil.importExcel(ExcelImportUtil.java:70)
at com.xuxueli.poi.excel.ExcelImportUtil.importExcel(ExcelImportUtil.java:135)

[rajbhandarisubodh]

The cell has interger value so you need to getNemericCellValue();
For example: sheet.getRow().getCell().getNumericCellValue();

[zoransi]

switch(cell){
case NUMERIC:
intVal = row.getCell(j).getNumericCellValue();
System.out.print(intVal);
break;
case STRING:
stringVal = row.getCell(j).getStringCellValue();
System.out.print(stringVal);
break;
}