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

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>