XSSFFormulaEvaluator formulaEvaluator = new XSSFFormulaEvaluator((XSSFWorkbook)workBook); String formulaNumber=String.valueOf(formulaEvaluator.evaluate(number_Cell).getNumberValue());