Share via

2.6.133 CT_PivotTableData

  • Article

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/IEC29500-1:2016] section 18.10) that is specified by the pivotTableReference (section 2.4.1) element in the extension of a workbook (section 2.2.4.11).

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/IEC29500-1:2016] section 18.10) that is specified by the pivotTableReference (section 2.4.1) element in the extension of a workbook (section 2.2.4.11).

Attributes:

rowCount: An unsignedInt ([XMLSCHEMA2/2] 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/IEC29500-1:2016] section 18.10.1.84.

columnCount: An unsignedInt ([XMLSCHEMA2/2] 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/IEC29500-1:2016] section 18.10.1.17) element.

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

The OLAP PivotTable PivotCache that is specified by this attribute MUST be extended by an ext ([ISO/IEC29500-1:2016] 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.138) element.

The following W3C XML Schema ([XMLSCHEMA1/2] 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/2] section 2.1).