Excel导入的时候读取公式单元格的值

Excel导入的时候读取公式单元格的值

/**
     * 获取表格单元格Cell内容
     * @param cell
     * @return
     */
    private static String getCellValue(Cell cell) {

        String result = new String();  
        switch (cell.getCellType()) {  
        case Cell.CELL_TYPE_NUMERIC:// 数字类型  
            ...
            break;  
        case Cell.CELL_TYPE_STRING:// String类型    
            ...
            break;  
        case Cell.CELL_TYPE_FORMULA: //公式类型 
        	HSSFFormulaEvaluator eva= new HSSFFormulaEvaluator((HSSFWorkbook) cell.getSheet().getWorkbook());
        	CellValue cellVal = eva.evaluate(cell);
        	 try {
        		 result = String.valueOf(cellVal.getNumberValue());
             } catch (IllegalStateException e) {
            	 result = String.valueOf(cell.getNumericCellValue());
             }
            break; 
        default:  
            result = "";  
            break;  
        }  
        return result;  
    }