Examples of ExternalSheet

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

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
96
  SheetRefEvaluator createExternSheetRefEvaluator(ExternSheetReferenceToken ptg) {
    return createExternSheetRefEvaluator(ptg.getExternSheetIndex());
  }
  SheetRefEvaluator createExternSheetRefEvaluator(int externSheetIndex) {
    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

398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
    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

1757
1758
1759
1760
1761
1762
1763
    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

1785
1786
1787
1788
1789
1790
1791
    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

29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    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();
            if (wbName != null) {
                sb = new StringBuffer(wbName.length() + sheetName.length() + cellRefText.length() + 4);
                SheetNameFormatter.appendFormat(sb, wbName, sheetName);
            } else {
                sb = new StringBuffer(sheetName.length() + cellRefText.length() + 4);
View Full Code Here

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

1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        if (extNames.length == 2) {
            return new ExternalSheet(extNames[0], extNames[1]);
        } else {
            return new ExternalSheetRange(extNames[0], extNames[1], extNames[2]);
        }
    }
View Full Code Here

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

1767
1768
1769
1770
1771
1772
1773
    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

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
96
  SheetRefEvaluator createExternSheetRefEvaluator(ExternSheetReferenceToken ptg) {
    return createExternSheetRefEvaluator(ptg.getExternSheetIndex());
  }
  SheetRefEvaluator createExternSheetRefEvaluator(int externSheetIndex) {
    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(), e);
      }
      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

272
273
274
275
276
277
278
279
280
281
282
283
284
285
      int lastRowIndex, int lastColumnIndex, int extSheetIndex) {
    SheetRefEvaluator sre = createExternSheetRefEvaluator(extSheetIndex);
    return new LazyAreaEval(firstRowIndex, firstColumnIndex, lastRowIndex, lastColumnIndex, sre);
  }
  public ValueEval getNameXEval(NameXPtg nameXPtg) {
      ExternalSheet externSheet = _workbook.getExternalSheet(nameXPtg.getSheetRefIndex());
      if(externSheet == null)
         return new NameXEval(nameXPtg);
      String workbookName = externSheet.getWorkbookName();
      ExternalName externName = _workbook.getExternalName(
            nameXPtg.getSheetRefIndex(),
            nameXPtg.getNameIndex()
      );
      try{
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.