public static String getValue(HSSFCell cell){
if (null != cell) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC: // 数字
return cell.getNumericCellValue()
+ "
";
case HSSFCell.CELL_TYPE_STRING: // 字符串
return cell.getStringCellValue()
+ "
";
case HSSFCell.CELL_TYPE_BOOLEAN: // Boolean
return cell.getBooleanCellValue()
+ "
";
case HSSFCell.CELL_TYPE_FORMULA: // 公式
return cell.getCellFormula() + "
";
case HSSFCell.CELL_TYPE_BLANK: // 空值
return "";
case HSSFCell.CELL_TYPE_ERROR: // 故障
return "";
default:
return "未知类型
";
}
}else{
return "";
}
}