RowItems Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Spreadsheet.RowItems

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(RowItem))> _
Public Class RowItems _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As RowItems

[ChildElementInfoAttribute(typeof(RowItem))]
public class RowItems : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

• RowItem <x:i>

[ISO/IEC 29500-1 1st Edition]

18.10.1.84 rowItems (Row Items)

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

[Example: In the SpreadsheetML example below, 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> 

Looking at the layout of the PivotTable in this example, "Bikes" is the first (and only) item value in the first row, in cell B10. In the XML defining the PivotTable row item values, the first <i> element corresponds to the first row. There is a single index element <x>. The first (and only) <x> element corresponds to the first field on the row axis, namely "Product Category", and an index value of "0" indicates that the 0th item in the items collection for that pivotField definition is how to obtain the item value. Note that "Bikes" isn't explicitly listed as a value here, but instead the 0th item is an index to this field's shared items collection in the pivotCacheDefinition part.

For the second row there are two item values, one item value (Bikes) from the first field in that row (Product Category) and one item value (Mountain Bikes) from the second field in that row (Product Subcategory). In the PivotTable, the first item value "Bikes" is hidden from view. In the XML for this example, the second <i> element expresses both item values for this row. The first item value "Bikes" is expressed implicitly, because the value of @r on the second <i> element is '1', indicating that the first item value from the previous row is reused again as the first item value for the current row. The second item value is expressed explicitly via the <x> element under the second <i> element. The index of '0' indicates that the 0th item in the <pivotField> element for that field is how to obtain the item value. Note again that the 0th item is itself an index into this field's shared items collection in the pivotCacheDefinition part.

The item values for the third row can be discovered in a similar way. end example]

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

© ISO/IEC29500: 2008.

Thread Safety

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

See Also

Reference

RowItems Members

DocumentFormat.OpenXml.Spreadsheet Namespace