2.5.50 ExtSheetPair
The ExtSheetPair structure specifies the sheet portion of a reference to a worksheet or macro sheet, or it specifies a range of worksheets or macro sheets in an external workbook (section 2.1.10). Formulas (section 2.2.2) use it in external defined names (section 2.2.7.4.1.1). The worksheets and macro sheets are in the collection of sheets in an external workbook, as specified by the BrtSupTabs (section 2.4.814) record.
The following packet diagram specifies this structure.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iTabFirst |
iTabLast |
||||||||||||||||||||||||||||||
iTabFirst (2 bytes): A signed integer that specifies the first sheet of a single or multisheet reference. The value of this field MUST be a value from the following table.
-
Value
Meaning
-1
Specifies that the first sheet of this reference cannot be found.
>= 0
Specifies the zero-based index of an XLWideString (section 2.5.169) type in the array specified by the sheetNames field in the BrtSupTabs record in this External Link (section 2.1.7.25) part ABNF. The referenced XLWideString (section 2.5.169) type MUST specify the name of a worksheet or macro sheet in the external workbook.
iTabLast (2 bytes): A signed integer that specifies the last sheet of a single or multisheet reference. The value of this field MUST be a value from the following table.
-
Value
Meaning
-1
Specifies that the last sheet of this reference cannot be found.
>= 0
Specifies the zero-based index of an XLWideString type in the array specified by the sheetNames field in the BrtSupTabs record in this External Link part. The referenced XLWideString type MUST specify the name of a worksheet or macro sheet in the external workbook. The value of this field MUST be greater than the value of iTabFirst.