poi读取的excel公式列换成数值

1.先获取FormulaEvaluator类

		   InputStream input=file.getInputStream();
           HSSFWorkbook workbook = new HSSFWorkbook(input);  
           HSSFSheet sheet = workbook.getSheet("文件名");
           FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();

2.判断cellType类型为CELL_TYPE_FORMULA时

CellValue cellValue = evaluator.evaluate(cell);
cellval=cellValue.getNumberValue();