3.5.3 External References: SupBook 1
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.
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 |
Figure 37: Structure of SupBook
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.