2.1.1720 Part 1 Section 22.2.2.8, HeadingPairs (Heading Pairs)
a. The standard does not document restrictions.
In Office, a specific order and variant type is required for each heading pair. The baseType of the vector should be “variant”. The following table specifies the order and the variant type of each heading pair:
Variant type |
Description |
---|---|
lpstr or lpwstr |
Specifies the heading for the group |
i4 |
Specifies the number of parts in the group. This value should be a positive integer. |
b. The standard does not include HeadingPairs for SpreadsheetML.
In Excel, the following heading pair values are specified:
Value Pair |
Meaning |
---|---|
SheetType, n |
There are n of these types of sheets in the workbook. SheetType can be one of the following: Worksheet, Charts, and Dialogs. |
Named Ranges, n |
There are n named ranges in the workbook. |