<i>
(Row Items)
Represents the collection of items in the row region of the PivotTable. In this example the item values are found in cells B10:B13. For example "Bikes" is in B10, and corresponds to the first <i> element below.
<rowItems count="4"> <i> <x/> </i> <i r="1"> <x/> </i> <i r="1"> <x v="1"/> </i> <i t="grand"> <x/> </i> </rowItems>
Child Elements |
Subclause |
---|---|
|
Attributes |
Description |
---|---|
|
Specifies a zero-based index indicating the referenced data item it in a data field with multiple data items. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the number of items to repeat from the previous row item. Note: The first item has no @r explicitly written. Since a default of "0" is specified in the schema, for any item whose @r is missing, a default value of "0" is implied. The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
Specifies the type of the item. Value of 'default' indicates a grand total as the last row item value The possible values for this attribute are defined by the ST_ItemType simple type (§3.18.45). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_I">
<sequence>
<element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
</sequence>
<attribute name="t" type="ST_ItemType" default="data"/>
<attribute name="r" type="xsd:unsignedInt" default="0"/>
<attribute name="i" type="xsd:unsignedInt" default="0"/>
</complexType>