EXCEl中关于Cell中的各种值的类型判断

    private static String getCellValue(XSSFCell cell)
    {
//        DecimalFormat df = new DecimalFormat("#.#");
        String cellValue = null;
        if (cell == null) return null;
        switch (cell.getCellType())
        {
            case HSSFCell.CELL_TYPE_NUMERIC :
                if (HSSFDateUtil.isCellDateFormatted(cell))
                {
//                    需要对日期这一列进行设置样式，否则无法识别是日期类型还是数值类型
//                    默认不支持中文日期类型，需要设置成纯英语日期类型，不要包含年月日等汉字
//                    最好是使用这种格式 2019/10/10 0:00
                    SimpleDateFormat sdf = new SimpleDateFormat(
                            "yyyy-MM-dd HH:mm:ss");
                    cellValue = sdf.format(HSSFDateUtil.getJavaDate(cell
                            .getNumericCellValue()));
                    break;
                }
//                cellValue = df.format(cell.getNumericCellValue());
                String v=String.format("%.4f",cell.getNumericCellValue());      //默认的整数后边是一个小数点，和一个零
                cellValue=(v).replaceAll("\\.0*$","");//整数作为浮点数格式化以后，删除结尾的点零
                break;
            case HSSFCell.CELL_TYPE_STRING :
                cellValue = String.valueOf(cell.getStringCellValue());
                break;
            case HSSFCell.CELL_TYPE_FORMULA ://XSSFCell.getCTCell()
                cellValue = cell.getCTCell().getV();//.getCachedFormulaResultType();//String.valueOf(cell..getCellFormula());
                break;
            case HSSFCell.CELL_TYPE_BLANK :
                cellValue = null;
                break;
            case HSSFCell.CELL_TYPE_BOOLEAN :
                cellValue = String.valueOf(cell.getBooleanCellValue());
                break;
            case HSSFCell.CELL_TYPE_ERROR :
                cellValue = String.valueOf(cell.getErrorCellValue());
                break;
        }
        if (cellValue != null && cellValue.trim().length() <= 0)
        {
            cellValue = null;
        }
        return cellValue;
    }

switch (cell.getCellType()){
    case Cell.CELL_TYPE_NUMERIC: //数字
        cellValue = stringDateProcess(cell);
        break;
    case Cell.CELL_TYPE_STRING: //字符串
        cellValue = String.valueOf(cell.getStringCellValue());
        break;
    case Cell.CELL_TYPE_BOOLEAN: //Boolean
        cellValue = String.valueOf(cell.getBooleanCellValue());
        break;
    case Cell.CELL_TYPE_FORMULA: //公式
        cellValue = String.valueOf(cell.getCellFormula());
        break;
    case Cell.CELL_TYPE_BLANK: //空值
        cellValue = "";
        break;
    case Cell.CELL_TYPE_ERROR: //故障
        cellValue = "非法字符";
        break;
    default:
        cellValue = "未知类型";
        break;
}