报错: java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell, 无法将数值类型转化成String
原因: getStringCellValue()无法将数值类型转化为string
解决方法:根据cell的type, 将结果都转为String
private String getCellValue(Cell cell) {
String result = null;
switch (cell.getCellTypeEnum()) {
case BLANK:
result = "";
break;
case NUMERIC:
result = String.valueOf(cell.getNumericCellValue());
break;
case FORMULA:
result = String.valueOf(cell.getCellFormula());
break;
case STRING:
result = cell.getStringCellValue();
break;
default:
break;
}
return result;
}