java用poi读取excel报错

java.lang.IllegalStateException: Cannot get a text value from a numeric formula cell序号=====
	at org.apache.poi.xssf.usermodel.XSSFCell.typeMismatch(XSSFCell.java:845)
	at org.apache.poi.xssf.usermodel.XSSFCell.checkFormulaCachedValueType(XSSFCell.java:302)
	at org.apache.poi.xssf.usermodel.XSSFCell.getRichStringCellValue(XSSFCell.java:290)
	at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.java:246)
	at Salary.readExcel(Salary.java:87)
	at Salary.main(Salary.java:114)

大体位置是：

 case Cell.CELL_TYPE_FORMULA: 
                            if (!cell.getStringCellValue().equals("")) {  
                                value = cell.getStringCellValue();  
                             } else {  
                                value = cell.getNumericCellValue() + "";  
                             }  
                            break;  

添加一段
cell.setCellType(Cell.CELL_TYPE_STRING);
修改为：

 case Cell.CELL_TYPE_FORMULA: 
                        	cell.setCellType(Cell.CELL_TYPE_STRING);
                            if (!cell.getStringCellValue().equals("")) {  
                                value = cell.getStringCellValue();  
                             } else {  
                                value = cell.getNumericCellValue() + "";  
                             }  
                            break;