pivotAreas (Pivot Areas)

Represents the collection of pivot areas that comprise the PivotTable location.

[Example:

<sh:pivotAreas count="1">
<sh:pivotArea field="2" dataOnly="0" outline="0"/>
</sh:pivotAreas>

end example]

Parent Elements

conditionalFormat (§3.10.1.18)

 

Child Elements	Subclause
pivotArea (Pivot Area)	§3.3.1.66

 

Attributes	Description
count (Pivot Area Count)	Specifies the number of PivotAreas for the PivotTable location.   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_PivotAreas">

   <sequence>

   <element name="pivotArea" minOccurs="0" maxOccurs="unbounded" type="CT_PivotArea"/>

   </sequence>

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

</complexType>