poi get cell value is formula

方法一：已验证，好使              

switch (cell.getCellType()) {

                  

                    case Cell.CELL_TYPE_FORMULA:

                         cell.setCellType(Cell.CELL_TYPE_STRING);

                        String str = cell.getStringCellValue();

                         break ;

                     default :

                        String str = "" ;

                         break ;

                     }




方法二：在我的读取中，不好使，不知道是不是excel版本问题，大家可以试试




if (aCell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
                   String str = aCell.getCellFormula();
}