3.5.7 External References: ExternSheet
The next record in this example, ExternSheet, specifies a collection of XTI records that specify the supporting link information.
Size |
Structure |
Value |
---|---|---|
000E |
ExternSheet - ExtSheet |
|
0002 |
USHORT - cXTI |
0x0002 |
000C |
XTI - rgXTI |
|
0006 |
XTI - xti[0] |
|
0002 |
USHORT - iSupBook |
0x0000 |
0002 |
SHORT - itabFirst |
0x0000 |
0002 |
SHORT - itabLast |
0x0000 |
0006 |
XTI - xti[1] |
|
0002 |
USHORT - iSupBook |
0x0001 |
0002 |
SHORT - itabFirst |
0x0000 |
0002 |
SHORT - itabLast |
0x0000 |
Figure 41: Structure of ExtSheet
cXTI: 0x0002 specifies that there are two elements in the rgXTI array.
rgXTI: An array of XTI elements. The number of elements in the array is specified by the cXTI field.
rgXTI.xti[0]: This is the first XTI element in the array.
rgXTI.xti[0].iSupBook: 0x0000 specifies the reference to the first SupBook record in the global substream.
rgXTI.xti[0].itabFirst: 0x0000 specifies that the supporting link has a sheet-level scope and specifies the first sheet, within the referenced workbook, that is in scope. The first sheet in scope is Sheet1.
rgXTI.xti[0].itabLast: 0x0000 specifies that the supporting link has a sheet-level scope and specifies the last sheet, within the referenced workbook, that is in scope. The last sheet in scope is Sheet1.
rgXTI.xti[1]: This is the second XTI element in the array. (The details of the referenced XTI record are omitted for brevity.)
rgXTI.xti[1].iSupBook: 0x0001 specifies the reference to the second SupBook record in the global substream.