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

Stack Overflow | Abid357 | 4 months ago
  1. 0

    FormulaEvaluator.evaluateAll() with external references in Excel cells returns RuntimeException using Apache POI

    Stack Overflow | 4 months ago | Abid357
    java.lang.RuntimeException: Could not resolve external workbook name 'b.xlsx'. Workbook environment has not been set up.
  2. 0

    Formula evaluation in excel using Apache poi

    Stack Overflow | 1 year ago | Deepak Kumar
    java.lang.RuntimeException: Could not resolve external workbook name '/**/**.xlsx'. Workbook environment has not been set up.
  3. 0

    selenium | Apache Help Blog

    filegala.com | 8 months ago
    java.lang.RuntimeException: Could not resolve external workbook name 'GMA%204.5.x-Fast%20Fail%20Test%20Script.xls'. Workbook environment has not been set up.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I have a Excel-template eith a Sheet named "Page 6 DATA" with a formula looking like this =INDIRECT("'Page 6 DATA'!R1C1",false) This formula causes the following Error when "Force formula recalulating" is set in the "Microsoft Excel Writer" Step Log: 2015/10/26 14:32:54 - Block this step until steps Select values Page 6 DATA finish.0 - Finished processing (I=0, O=0, R=6, W=6, U=0, E=0) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : java.lang.RuntimeException: R1C1 style not supported yet 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluationContext.getDynamicReference(OperationEvaluationContext.java:150) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluateIndirect(Indirect.java:124) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluate(Indirect.java:76) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:127) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:525) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.recalculateAllWorkbookFormulas(ExcelWriterStep.java:249) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:227) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:183) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at java.lang.Thread.run(Thread.java:695) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - Finished processing (I=0, O=7, R=6, W=6, U=0, E=1) The poi library seems to be the problem https://poi.apache.org/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html#getDynamicReference%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean%29 "isA1Style - specifies the format for refStrPart1 and refStrPart2. Pass true for 'A1' style and false for 'R1C1' style. TODO - currently POI only supports 'A1' reference style" It looks like this is an very old issue. Here is one possible solution that is 13 years old? "R1C1 is not supported, and there is no plan to add that support as yet. If you want to easily convert numeric references to A1 style references easily, you can use the AreaReference and CellReference classes in the hssf.util package, which have useful constructors, and whose toString() methods return A1 style references. (remember to use zero based references) " http://user.poi.apache.narkive.com/ra4GFwo4/support-for-r1c1-reference-style

    Pentaho BI Platform Tracking | 1 year ago | Nikolai Sandved
    java.lang.RuntimeException: R1C1 style not supported yet
  6. 0

    I have a Excel-template eith a Sheet named "Page 6 DATA" with a formula looking like this =INDIRECT("'Page 6 DATA'!R1C1",false) This formula causes the following Error when "Force formula recalulating" is set in the "Microsoft Excel Writer" Step Log: 2015/10/26 14:32:54 - Block this step until steps Select values Page 6 DATA finish.0 - Finished processing (I=0, O=0, R=6, W=6, U=0, E=0) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : Unexpected error 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - ERROR (version 5.3.0.0-213, build 1 from 2015-02-02_12-17-08 by buildguy) : java.lang.RuntimeException: R1C1 style not supported yet 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluationContext.getDynamicReference(OperationEvaluationContext.java:150) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluateIndirect(Indirect.java:124) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.functions.Indirect.evaluate(Indirect.java:76) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:127) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:525) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:288) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:264) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:151) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.recalculateAllWorkbookFormulas(ExcelWriterStep.java:249) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:227) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:183) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - at java.lang.Thread.run(Thread.java:695) 2015/10/26 14:32:55 - Microsoft Excel Writer Page 6 DATA.0 - Finished processing (I=0, O=7, R=6, W=6, U=0, E=1) The poi library seems to be the problem https://poi.apache.org/apidocs/org/apache/poi/ss/formula/OperationEvaluationContext.html#getDynamicReference%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean%29 "isA1Style - specifies the format for refStrPart1 and refStrPart2. Pass true for 'A1' style and false for 'R1C1' style. TODO - currently POI only supports 'A1' reference style" It looks like this is an very old issue. Here is one possible solution that is 13 years old? "R1C1 is not supported, and there is no plan to add that support as yet. If you want to easily convert numeric references to A1 style references easily, you can use the AreaReference and CellReference classes in the hssf.util package, which have useful constructors, and whose toString() methods return A1 style references. (remember to use zero based references) " http://user.poi.apache.narkive.com/ra4GFwo4/support-for-r1c1-reference-style

    Pentaho BI Platform Tracking | 1 year ago | Nikolai Sandved
    java.lang.RuntimeException: R1C1 style not supported yet

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.poi.ss.formula.CollaboratingWorkbooksEnvironment$WorkbookNotFoundException

      Could not resolve external workbook name 'b.xlsx'. Workbook environment has not been set up.

      at org.apache.poi.ss.formula.CollaboratingWorkbooksEnvironment.getWorkbookEvaluator()
    2. POI
      WorkbookEvaluator.evaluate
      1. org.apache.poi.ss.formula.CollaboratingWorkbooksEnvironment.getWorkbookEvaluator(CollaboratingWorkbooksEnvironment.java:195)
      2. org.apache.poi.ss.formula.WorkbookEvaluator.getOtherWorkbookEvaluator(WorkbookEvaluator.java:156)
      3. org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:111)
      4. org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:84)
      5. org.apache.poi.ss.formula.OperationEvaluationContext.getRef3DEval(OperationEvaluationContext.java:313)
      6. org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:634)
      7. org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:505)
      8. org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:263)
      9. org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:205)
      9 frames
    3. Apache POI
      BaseXSSFFormulaEvaluator.evaluateFormulaCell
      1. org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:189)
      2. org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCell(BaseXSSFFormulaEvaluator.java:117)
      2 frames
    4. POI
      HSSFFormulaEvaluator.evaluateAllFormulaCells
      1. org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:346)
      2. org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:337)
      2 frames
    5. Apache POI
      XSSFFormulaEvaluator.evaluateAll
      1. org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAll(XSSFFormulaEvaluator.java:105)
      1 frame
    6. Unknown
      Test.main
      1. Test.main(Test.java:28)
      1 frame