2.1.1711 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.

Show: