PivotFields Class
PivotTable Fields.When the object is serialized out as xml, its qualified name is x:pivotFields.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.PivotFields
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(PivotField))> _
Public Class PivotFields _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotFields
[ChildElementInfoAttribute(typeof(PivotField))]
public class PivotFields : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- PivotField <x:pivotField>
[ISO/IEC 29500-1 1st Edition]
18.10.1.70 pivotFields (PivotTable Fields)
Represents the collection of fields that appear on the PivotTable.
[Example:
<pivotFields count="28">
<pivotField showAll="0" includeNewItemsInFilter="1">
<items count="8">
<item x="66"/>
<item x="133"/>
<item x="74"/>
<item x="27"/>
<item x="118"/>
<item x="63"/>
<item x="141"/>
<item t="default"/>
</items>
</pivotField>
<pivotField showAll="0" includeNewItemsInFilter="1"/>
<pivotField axis="axisPage" showAll="0" includeNewItemsInFilter="1">
<items count="2">
<item x="0"/>
<item t="default"/>
</items>
</pivotField>
<pivotField showAll="0" includeNewItemsInFilter="1"/>
end example]
Parent Elements |
|---|
pivotTableDefinition (§18.10.1.73) |
Child Elements |
Subclause |
|---|---|
pivotField (PivotTable Field) |
§18.10.1.69 |
Attributes |
Description |
|---|---|
count (Field Count) |
Specifies the number of fields in the PivotTable. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_PivotFields) 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.