[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

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:2011] 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/IEC29500-1:2011] 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/IEC29500-1:2011] section 18.10.1.17) element.