Examples of ExternalSheet

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

78
79
80
81
82
83
84
85
  SheetRangeEvaluator createExternSheetRefEvaluator(ExternSheetReferenceToken ptg) {
    return createExternSheetRefEvaluator(ptg.getExternSheetIndex());
  }
  SheetRangeEvaluator createExternSheetRefEvaluator(String firstSheetName, String lastSheetName, int externalWorkbookNumber) {
        ExternalSheet externalSheet = _workbook.getExternalSheet(firstSheetName, lastSheetName, externalWorkbookNumber);
        return createExternSheetRefEvaluator(externalSheet);
    }
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

82
83
84
85
86
87
88
89
  SheetRangeEvaluator createExternSheetRefEvaluator(String firstSheetName, String lastSheetName, int externalWorkbookNumber) {
        ExternalSheet externalSheet = _workbook.getExternalSheet(firstSheetName, lastSheetName, externalWorkbookNumber);
        return createExternSheetRefEvaluator(externalSheet);
    }
  SheetRangeEvaluator createExternSheetRefEvaluator(int externSheetIndex) {
    ExternalSheet externalSheet = _workbook.getExternalSheet(externSheetIndex);
        return createExternSheetRefEvaluator(externalSheet);
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
                aptg.getLastRow(), aptg.getLastColumn(), sre);
    }
   
    public ValueEval getNameXEval(NameXPtg nameXPtg) {
        // Is the name actually on our workbook?
        ExternalSheet externSheet = _workbook.getExternalSheet(nameXPtg.getSheetRefIndex());
        if(externSheet == null || externSheet.getWorkbookName() == null) {
            // External reference to our own workbook's name
            return getLocalNameXEval(nameXPtg);
        }
       
        // Look it up for the external workbook
        String workbookName = externSheet.getWorkbookName();
        ExternalName externName = _workbook.getExternalName(
              nameXPtg.getSheetRefIndex(),
              nameXPtg.getNameIndex()
        );
        return getExternalNameXEval(externName, workbookName);
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
              nameXPtg.getNameIndex()
        );
        return getExternalNameXEval(externName, workbookName);
    }
  public ValueEval getNameXEval(NameXPxg nameXPxg) {
      ExternalSheet externSheet = _workbook.getExternalSheet(nameXPxg.getSheetName(), null, nameXPxg.getExternalWorkbookNumber());
        if(externSheet == null || externSheet.getWorkbookName() == null) {
            // External reference to our own workbook's name
            return getLocalNameXEval(nameXPxg);
        }
 
        // Look it up for the external workbook
        String workbookName = externSheet.getWorkbookName();
        ExternalName externName = _workbook.getExternalName(
              nameXPxg.getNameName(),
              nameXPxg.getSheetName(),
              nameXPxg.getExternalWorkbookNumber()
        );
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
    return (ValueEval) operation.evaluate(ops, srcRowNum, (short)srcColNum);
  }
  private SheetRefEvaluator createExternSheetRefEvaluator(EvaluationTracker tracker,
      ExternSheetReferenceToken ptg) {
    int externSheetIndex = ptg.getExternSheetIndex();
    ExternalSheet externalSheet = _workbook.getExternalSheet(externSheetIndex);
    if (externalSheet != null) {
      WorkbookEvaluator otherEvaluator = _collaboratingWorkbookEnvironment.getWorkbookEvaluator(externalSheet.getWorkbookName());
      EvaluationWorkbook otherBook = otherEvaluator._workbook;
      int otherSheetIndex = otherBook.getSheetIndex(externalSheet.getSheetName());
      return new SheetRefEvaluator(otherEvaluator, tracker, otherBook, otherSheetIndex);
    }
    int otherSheetIndex = _workbook.convertFromExternSheetIndex(externSheetIndex);
    return new SheetRefEvaluator(this, tracker, _workbook, otherSheetIndex);
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

1755
1756
1757
1758
1759
1760
1761
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    return _columnIndex;
  }

  /* package */ SheetRefEvaluator createExternSheetRefEvaluator(ExternSheetReferenceToken ptg) {
    int externSheetIndex = ptg.getExternSheetIndex();
    ExternalSheet externalSheet = _workbook.getExternalSheet(externSheetIndex);
    WorkbookEvaluator targetEvaluator;
    int otherSheetIndex;
    if (externalSheet == null) {
      // sheet is in same workbook
      otherSheetIndex = _workbook.convertFromExternSheetIndex(externSheetIndex);
      targetEvaluator = _bookEvaluator;
    } else {
      // look up sheet by name from external workbook
      String workbookName = externalSheet.getWorkbookName();
      try {
        targetEvaluator = _bookEvaluator.getOtherWorkbookEvaluator(workbookName);
      } catch (WorkbookNotFoundException e) {
        throw new RuntimeException(e.getMessage());
      }
      otherSheetIndex = targetEvaluator.getSheetIndex(externalSheet.getSheetName());
      if (otherSheetIndex < 0) {
        throw new RuntimeException("Invalid sheet name '" + externalSheet.getSheetName()
            + "' in bool '" + workbookName + "'.");
      }
    }
    return new SheetRefEvaluator(targetEvaluator, _tracker, otherSheetIndex);
  }
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

1756
1757
1758
1759
1760
1761
1762
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
  private ExternSheetNameResolver() {
    // no instances of this class
  }

  public static String prependSheetName(FormulaRenderingWorkbook book, int field_1_index_extern_sheet, String cellRefText) {
    ExternalSheet externalSheet = book.getExternalSheet(field_1_index_extern_sheet);
    StringBuffer sb;
    if (externalSheet != null) {
      String wbName = externalSheet.getWorkbookName();
      String sheetName = externalSheet.getSheetName();
      sb = new StringBuffer(wbName.length() + sheetName.length() + cellRefText.length() + 4);
      SheetNameFormatter.appendFormat(sb, wbName, sheetName);
    } else {
      String sheetName = book.getSheetNameByExternSheet(field_1_index_extern_sheet);
      sb = new StringBuffer(sheetName.length() + cellRefText.length() + 4);
View Full Code Here

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

1784
1785
1786
1787
1788
1789
1790
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.