java.lang.RuntimeException: Could not resolve external workbook name 'CP.xls'. Workbook environment has not been set up.

coderanch.com | 9 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Reading only text content of the foruma cell + POI 3.5 (Open Source Projects forum at Coderanch)

    coderanch.com | 9 months ago
    java.lang.RuntimeException: Could not resolve external workbook name 'CP.xls'. Workbook environment has not been set up.
  2. 0

    Reading only text content of the foruma cell + POI 3.5

    Coderanch | 7 years ago | Jigar Naik
    java.lang.RuntimeException: Could not resolve external workbook name 'CP.xls'. Workbook environment has not been set up.

    Root Cause Analysis

    1. java.lang.RuntimeException

      Could not resolve external workbook name 'CP.xls'. Workbook environment has not been set up.

      at org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator()
    2. POI
      HSSFFormulaEvaluator.evaluateFormulaCell
      1. org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:87)
      2. org.apache.poi.ss.formula.OperationEvaluationContext.getRef3DEval(OperationEvaluationContext.java:244)
      3. org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:561)
      4. org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:439)
      5. org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:260)
      6. org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:206)
      7. org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:317)
      8. org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:210)
      8 frames
    3. com.ofss.excel
      ExcelReader.main
      1. com.ofss.excel.read.usermodel.ExcelReader.displayExcelToConsole(ExcelReader.java:61)
      2. com.ofss.excel.read.usermodel.ExcelReader.main(ExcelReader.java:34)
      2 frames