Share via

2.4.63 pivotTableData

  • Article

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

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

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