RowItem Class
Row Items.When the object is serialized out as xml, its qualified name is x:i.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.RowItem
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(MemberPropertyIndex))> _
Public Class RowItem _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As RowItem
[ChildElementInfoAttribute(typeof(MemberPropertyIndex))]
public class RowItem : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- MemberPropertyIndex <x:x>
[ISO/IEC 29500-1 1st Edition]
18.10.1.44 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.
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.