[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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.

[Example:

<rowItems count="4">
<i>
<x/>
</i>

<i r="1">
<x/>
</i>

<i r="1">
<x v="1"/>
</i>

<i t="grand">
<x/>
</i>
</rowItems>

end example]

Parent Elements

colItems3.10.1.17); rowItems3.10.1.84)

 

Child Elements

Subclause

x (Member Property Index)

§3.10.1.96

 

Attributes

Description

i (Data Field Index)

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.

r (Repeated Items Count)

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.

t (Item Type)

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>