该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
//上面的getCellValue
private static String getCellValue(HSSFCell cell) {
String cellString = "";
if (cell != null) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:// Number类型
DecimalFormat df = new DecimalFormat("0");
cellString = df.format(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_BOOLEAN:// boolean类型
cellString = cell.getBooleanCellValue() + "";
break;
case HSSFCell.CELL_TYPE_BLANK:// 空值
cellString = "";
break;
case HSSFCell.CELL_TYPE_STRING: // string类型 要注意下空白
cellString = cell.getStringCellValue();
if (cellString.trim() == "" || cellString.trim().length() < 0) {
cellString = "";
}
break;
case HSSFCell.CELL_TYPE_ERROR:// 错误类型
cellString = "";
break;
case HSSFCell.CELL_TYPE_FORMULA:// 格式化类型
cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
cellString = String.valueOf(cell.getNumericCellValue());
break;
default:
cellString = cell.toString();
;// 默认值
break;
}
}
return cellString;
}