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.