title: Java POI : How to read Excel cell value and not the formula computing it?
body: <p>I am using Apache POI API to getting values from an Excel file. 
  Everything is working great except with cells containing formulas. In fact, the <code>cell.getStringCellValue()</code> is returning the formula used in the cell and not the value of the cell. </p>
  
  <p>I tried to use <code>evaluateFormulaCell()</code> method but it's not working because I am using GETPIVOTDATA Excel formula and this formula is not implemented in the API:</p>
  
  <pre><code>Exception in thread "main" org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell Landscape!K11
      at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:321)
      at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288)
      at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221)
      at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:320)
      at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:213)
      at fromExcelToJava.ExcelSheetReader.unAutreTest(ExcelSheetReader.java:193)
      at fromExcelToJava.ExcelSheetReader.main(ExcelSheetReader.java:224)
  Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: GETPIVOTDATA
      at org.apache.poi.hssf.record.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:42)
  </code></pre>