RowItem class

Office 2013 and later

Row Items. When the object is serialized out as xml, its qualified name is x:i.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

i (Row Items)

Represents the collection of items in the row region of the PivotTable.

[Example: 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>

end example]

Parent Elements

colItems (§18.10.1.17); rowItems (§18.10.1.84)

Child Elements

Subclause

x (Member Property Index)

§18.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 W3C XML Schema unsignedInt datatype.

r (Repeated Items Count)

Specifies the number of items to repeat from the previous row item. 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 W3C 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 (§18.18.43).

[Note: The W3C XML Schema definition of this element’s content model (CT_I) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: