Export (0) Print
Expand All

3.5.3 External References: SupBook 1

Office

The next record in this example, Supbook, specifies an external workbook referencing supporting link and specifies the beginning of a collection of records that specifies the referenced cell (B3) in the External Workbook (Book1.xls). This record is the first SupBook record in the global substream.

The workbook of the referenced cell (Book1.xls) is specified in the Supbook record. The sheet of the referenced cell (Sheet1) is specified in the XCT record following this record. The referenced cell (B3) is specified in the CRN record following the XCT record.

Structure of SupBook

Size

Structure

Value

002A

SupBook - SupBook

0002

    USHORT - ctab

0x0003

0002

    USHORT - cch

0x000A

000B

    XLUnicodeStringNoCch- virtPath

Book1.xls

001B

    XLUnicodeString- rgst

0009

        XLUnicodeString - rgst[0]

Sheet1

0009

        XLUnicodeString - rgst[1]

Sheet2

0009

        XLUnicodeString - rgst[2]

Sheet3

ctab: 0x0003 specifies that there are three sheets in the referenced workbook.

cch: 0x000A specifies that there are 10 characters in virtPath.

virtPath: Book1.xls specifies the encoded path of the referenced workbook. The length of the string is 10 characters, but the first character is an unprintable Unicode character with a value of 0x01.

rgst: Specifies an array of three sheets contained within the referenced workbook.

rgst.rgst[0]: Sheet1 specifies the name of the first sheet in the referenced workbook.

rgst.rgst[1]: Sheet2 specifies the name of the second sheet in the referenced workbook.

rgst.rgst[2]: Sheet3 specifies the name of the third sheet in the referenced workbook.

Show:
© 2014 Microsoft