[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

pageFields (Page Field Items)

Represents the collection of items in the page or report filter region of the PivotTable.

[Example:

<sh:pageFields count="2">
<sh:pageField fld="43" hier="103"
name="[Product].[Product Categories].[All Products]" cap="All Products"/>
<sh:pageField fld="66" hier="126"
name="[Promotion].[Promotions].[All Promotions]" cap="All Promotions"/>
</sh:pageFields>

end example]

Parent Elements

pivotTableDefinition3.10.1.73)

 

Child Elements

Subclause

pageField (Page Field)

§3.10.1.62

 

Attributes

Description

count (Page Item Count)

Specifies the number of items in the page region of the PivotTable.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_PageFields">

   <sequence>

   <element name="pageField" maxOccurs="unbounded" type="CT_PageField"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt"/>

</complexType>