PivotTableData class

2.4.63 pivotTableData

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A pivotTableData element<40> is a CT_PivotTableData element that specifies the PivotValues of a PivotTable ([ISO/IEC-29500-1] section 18.10), specified by the pivotTableReference element in the extension of a workbook. See section 2.2.4.4 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1]. If the PivotTable ([ISO/IEC-29500-1] section 18.10) is not a Non-Worksheet PivotTable, MUST NOT be specified.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="pivotTableData" type="CT_PivotTableData"/>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.133 CT_PivotTableData

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: pivotTableData

The CT_PivotTableData complex type specifies the PivotValues (section 2.3.4) of the PivotTable ([ISO/IEC-29500-1] section 18.10) that is specified by the pivotTableReference (section 2.4.1) element in the extension of a workbook (section 2.2.4.10).<109>

Child Elements:

pivotRow: A CT_PivotRow (section 2.6.134) element that specifies a single row of PivotValueCells (section 2.3.4.1) in an element of this type in the PivotTable ([ISO/IEC-29500-1] section 18.10) that is specified by the pivotTableReference (section 2.4.1) element in the extension of a workbook (section 2.2.4.10).

Attributes:

rowCount: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of pivotRow child elements in an element of this type. This value MUST be equal to the value of the count attribute of the rowItems element, as specified in [ISO/IEC-29500-1] section 18.10.1.84.

columnCount: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute specifying the number of PivotValueCells (section 2.3.4.1) that are specified by the CT_PivotValueCell (section 2.6.135) complex type in each of the pivotRow child elements of this type. This value MUST be equal to the value of the count attribute in the pivotRow element, as specified by the CT_PivotRow (section 2.6.134) complex type. This value MUST be equal to the value of the count attribute of the colItems, ([ISO/IEC-29500-1] section 18.10.1.17) element.

cacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the associated OLAP PivotTable ([ISO/IEC-29500-1] section 18.10) PivotCache.

The OLAP PivotTable PivotCache that is specified by this attribute MUST be extended by an ext ([ISO/IEC-29500-1] section 18.2.7) element that has a structure specified by a CT_PivotCacheDefinition (section 2.6.33) element. The pivotCacheId attribute of such a CT_PivotCacheDefinition element MUST be equal to this attribute.

The OLAP PivotTable PivotCache that is specified by this attribute MUST also be extended by an ext element that has structure specified by a CT_PivotCacheIdVersion (section 2.6.139) element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_PivotTableData">

<xsd:sequence>

<xsd:element name="pivotRow" type="CT_PivotRow" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

<xsd:attribute name="rowCount" type="xsd:unsignedInt" use="required"/>

<xsd:attribute name="columnCount" type="xsd:unsignedInt" use="required"/>

<xsd:attribute name="cacheId" type="xsd:unsignedInt" use="required"/>

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Reference