共用方式為


PivotField Class

Definition

PivotTable Field.

This class is available in Office 2007 and above.

When the object is serialized out as xml, it's qualified name is x:pivotField.

[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))]
[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
[DocumentFormat.OpenXml.SchemaAttr(22, "pivotField")]
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
[DocumentFormat.OpenXml.SchemaAttr(22, "pivotField")]
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
[DocumentFormat.OpenXml.SchemaAttr("x:pivotField")]
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
[DocumentFormat.OpenXml.SchemaAttr("x:pivotField")]
public class PivotField : DocumentFormat.OpenXml.TypedOpenXmlCompositeElement
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))]
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))]
[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
public class PivotField : DocumentFormat.OpenXml.OpenXmlCompositeElement
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))>]
[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
[<DocumentFormat.OpenXml.SchemaAttr(22, "pivotField")>]
type PivotField = class
    inherit OpenXmlCompositeElement
type PivotField = class
    inherit OpenXmlCompositeElement
[<DocumentFormat.OpenXml.SchemaAttr(22, "pivotField")>]
type PivotField = class
    inherit OpenXmlCompositeElement
[<DocumentFormat.OpenXml.SchemaAttr("x:pivotField")>]
type PivotField = class
    inherit OpenXmlCompositeElement
[<DocumentFormat.OpenXml.SchemaAttr("x:pivotField")>]
type PivotField = class
    inherit TypedOpenXmlCompositeElement
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))>]
type PivotField = class
    inherit OpenXmlCompositeElement
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Items))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.AutoSortScope))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.PivotFieldExtensionList))>]
[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
type PivotField = class
    inherit OpenXmlCompositeElement
Public Class PivotField
Inherits OpenXmlCompositeElement
Public Class PivotField
Inherits TypedOpenXmlCompositeElement
Inheritance
Inheritance
Attributes

Remarks

[ISO/IEC 29500-1 1st Edition]

pivotField (PivotTable Field)

Represents a single field in the PivotTable. This element contains information about the field, including the collection of items in the field.

[Example:

<pivotField axis="axisRow" allDrilled="1" showAll="0" measureFilter="1"  sortType="descending">  
  <items count="8">  
    <item s="1" c="1" x="0"/>  
    <item s="1" c="1" x="1"/>  
    <item c="1" x="2"/>  
    <item c="1" x="3"/>  
    <item c="1" x="4"/>  
    <item c="1" x="5"/>  
    <item c="1" x="6"/>  
    <item t="default"/>  
  </items>  
  <autoSortScope>  
    <pivotArea dataOnly="0" outline="0" fieldPosition="0">  
      <references count="2">  
        <reference field="4294967294" count="1" selected="0">  
          <x v="0"/>  
        </reference>  
        <reference field="25" count="1" selected="0">  
          <x v="0"/>  
        </reference>  
      </references>  
    </pivotArea>  
  </autoSortScope>  
</pivotField>  

end example]

Parent Elements
pivotFields (§18.10.1.70)
Child Elements Subclause
autoSortScope (AutoSort Scope) §18.10.1.1
extLst (Future Feature Data Storage Area) §18.2.10
items (Field Items) §18.10.1.46
Attributes Description
allDrilled (All Items Expanded) Specifies a boolean value that indicates whether all items in the field are expanded. Applies only to OLAP PivotTables.

A value of 1 or true indicates all items in the field are expanded.

A value of 0 or false indicates all items are not expanded. However some items might be expanded.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
autoShow (Auto Show) Specifies a boolean value that indicates whether an "AutoShow" filter is applied to this field. This attribute depends on the implementation of filtering in the application.

A value of 1 or true indicates an "AutoShow" filter is applied to the field.

A value of 0 or false indicates an "AutoShow" filter is not applied.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
avgSubtotal (Average) Specifies a boolean value that indicates whether to apply the 'Average' aggregation function in the subtotal of this field.

A value of 1 or true indicates the subtotal for this field is 'Average.'

A value of 0 or false indicates a different aggregation function is applied to the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
axis (Axis) Specifies the region of the PivotTable that this field is displayed.

The possible values for this attribute are defined by the ST_Axis simple type (§18.18.1).
compact (Compact) Specifies a boolean value that indicates whether the application will display fields compactly in the sheet on which this PivotTable resides.

A value of 1 or true indicates the next field should be displayed in the same column of the sheet.

A value of 0 or false indicates each pivot field will display in its own column in the sheet.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
countASubtotal (CountA) Specifies a boolean value that indicates whether to apply the 'countA' aggregation function in the subtotal of this field.

A value of 1 or true indicates the subtotal for this field is 'countA.'

A value of 0 or false indicates a different aggregation function is applied to the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
countSubtotal (Count) Specifies a boolean value that indicates whether to apply the 'count' aggregation function in the subtotal of this field.

A value of 1 or true indicates the subtotal for this field is 'count.'

A value of 0 or false indicates a different aggregation vfunction is applied to the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dataField (Data Field) Specifies a boolean value that indicates whether this field appears in the data region of the PivotTable.

A value of 1 or true indicates this field appears in the data region of the PivotTable.

A value of 0 or false indicates this field appears in another region of the PivotTable.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dataSourceSort (Data Source Sort) Specifies a boolean value that indicates whether sort is applied to this field in the data source.

A value of 1 or true indicates this field is sorted in the data source.

A value of 0 or false indicates this field is not sorted in the data source.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
defaultAttributeDrillState (Drill State) Specifies a boolean value that indicates the drill state of the attribute hierarchy in an OLAP-based PivotTable.

A value of 1 or true indicates the attribute hierarchy is expanded.

A value of 0 or false indicates the attribute hierarchy is collapsed.

This attribute is designed to allow the application to issue more optimized queries when all items of each field have the same drill state.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
defaultSubtotal (Show Default Subtotal) Specifies a boolean value that indicates whether the default subtotal aggregation function is displayed for this field.

A value of 1 or true indicates the default subtotal aggregation function is displayed for this field.

A value of 0 or false indicates the default aggregation function is not displayed.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dragOff (Drag Off) Specifies a boolean value that indicates whether the field can be removed from the PivotTable.

A value of 1 or true indicates the field can be removed from the PivotTable.

A value of 0 or false indicates the field cannot be removed from the PivotTable.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dragToCol (Drag To Column) Specifies a boolean value that indicates whether the field can be dragged to the column axis.

A value of 1 or true indicates the field can be dragged to the column axis.

A value of 0 or false indicates the field cannot be dragged to the column axis.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dragToData (Field Can Drag to Data) Specifies a boolean value that indicates whether the field can be dragged to the data region.

A value of 1 or true indicates the field can be dragged to the data region.

A value of 0 or false indicates the field cannot be dragged to the data region.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dragToPage (Drag Field to Page) Specifies a boolean value that indicates whether the field can be dragged to the page region.

A value of 1 or true indicates the field can be dragged to the page region.

A value of 0 or false indicates the field cannot be dragged to the page region.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
dragToRow (Drag To Row) Specifies a boolean value that indicates whether the field can be dragged to the row axis.

A value of 1 or true indicates the field can be dragged to the row axis.

A value of 0 or false indicates the field cannot be dragged to the row axis.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
hiddenLevel (Hidden Level) Specifies a boolean value that indicates whether there is a hidden level in the PivotTable. This attribute applies to OLAP-based PivotTables only.

A value of 1 or true indicates the OLAP PivotTable contains a hidden level.

A value of 0 or false indicates the OLAP PivotTable does not contain any hidden levels.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
hideNewItems (Hide New Items) Specifies a boolean value that indicates whether new items that appear after a refresh should be hidden by default.

A value of 1 or true indicates that items that appear after a refresh should be hidden by default.

A value of 0 or false indicates that items that appear after a refresh should be shown by default.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
includeNewItemsInFilter (Inclusive Manual Filter) Specifies a boolean value that indicates whether manual filter is in inclusive mode.

A value of 1 or true indicates the manual filter is inclusive.

A value of 0 or false indicates the manual filter is not inclusive.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
insertBlankRow (Insert Blank Row) Specifies a boolean value that indicates whether to insert a blank row after each item.

A value of 1 or true indicates that a blank row is inserted after each item.

A value of 0 or false indicates no additional rows are inserted after each item.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
insertPageBreak (Insert Item Page Break) Specifies a boolean value that indicates whether to insert a page break after each item.

A value of 1 or true indicates that a page break is inserted after each item.

A value of 0 or false indicates no page breaks are inserted after items.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
itemPageCount (Items Per Page Count) Specifies the number of items showed per page in the PivotTable.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.
maxSubtotal (Max Subtotal) Specifies a boolean value that indicates whether to apply the 'max' aggregation function in the subtotal of this field.

A value of 1 or true indicates that the 'max' aggregation function is applied in the subtotal for this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
measureFilter (Measure Filter) Specifies a boolean value that indicates whether field has a measure based filter.

A value of 1 or true indicates the field has a measure-based filter.

A value of 0 or false indicates does not have a measure-based filter.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
minSubtotal (Min Subtotal) Specifies a boolean value that indicates whether to apply the 'min' aggregation function in the subtotal of this field.

A value of 1 or true indicates that the 'min' aggregation function is applied in the subtotal for this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
multipleItemSelectionAllowed (Multiple Field Filters) Specifies a boolean value that indicates whether the field can have multiple items selected in the page field.

A value of 1 or true indicates the PivotTable can have multiple items selected in the page field.

A value of 0 or false indicates the PivotTable cannot have multiple items selected in the page field. This attribute depends on the application support for selecting multiple items in page fields.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
name (Field Name) Specifies the name of the field.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).
nonAutoSortDefault (Auto Sort) Specifies a boolean value that indicates whether sort operation that is applied to field should be AutoSort operation or simple data sort operation.

A value of 1 or true indicates that an AutoSort operation is applied to the field.

A value of 0 or false indicates a simple data sort operation is applied to the field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
numFmtId (Number Format Id) Specifies the identifier of the number format to apply to this field. Number formats are written to the styles part. See the Styles section (§18.8) for more information on number formats.

Formatting information provided by cell table and by PivotTable need not agree. If the two formats differ, the cell-level formatting takes precedence. If you change the layout the PivotTable, the PivotTable formatting will then take precedence.

The possible values for this attribute are defined by the ST_NumFmtId simple type (§18.18.47).
outline (Outline Items) Specifies a boolean value that indicates whether the items in this field should be shown in Outline form.

A value of 1 or true indicates the items in this field is shown in Outline form.

A value of 0 or false indicates the items in this field will not be shown in Outline form. This attribute depends on the application support for displaying items in Outline form.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
productSubtotal (Product Subtotal) Specifies a boolean value that indicates whether to apply 'product' aggregation function in the subtotal of this field.

A value of 1 or true indicates that the 'product' aggregation function is applied in the subtotal for this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
rankBy (Auto Show Rank By) Specifies the index of the data field by which AutoShow will rank.

The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype.
serverField (Server-based Page Field) Specifies a boolean value that indicates whether this is a server-based page field.

A value of 1 or true indicates this is a server-based page field.

A value of 0 or false indicates this is a local page field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
showAll (Show All Items) Specifies a boolean value that indicates whether to show all items for this field.

A value of 1 or true indicates that all items be shown.

A value of 0 or false indicates items be shown according to user specified criteria.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
showDropDowns (Show PivotField Header Drop Downs) Specifies a boolean value that indicates whether to hide drop down buttons on PivotField headers. This attribute depends on the application implementation for filtering in the user interface.

A value of 1 or true indicates the application will display some mechanism for selecting and applying filters – [Example: A dropdown menu end example] – in the user interface.

A value of 0 or false indicates for mechanism for applying a filter is displayed in the user interface.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
showPropAsCaption (Show As Caption) Specifies a boolean value that indicates whether to show the property as a member caption.

A value of 1 or true indicates the property is shown as a member caption.

A value of 0 or false indicates the property will not be shown as a member caption.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
showPropCell (Show Member Property in Cell) Specifies a boolean value that indicates whether to show the member property value in a PivotTable cell.

A value of 1 or true indicates the property value is shown in a PivotTable cell.

A value of 0 or false indicates the property value will not be shown in a PivotTable cell.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
showPropTip (Show Member Property ToolTip) Specifies a boolean value that indicates whether to show the member property value in a tooltip on the appropriate PivotTable cells.

A value of 1 or true indicates the property value is shown in a tooltip in the user interface.

A value of 0 or false indicates the property will not be shown in a tooltip. This attribute depends on whether the application employs tooltips or similar mechanism in the user interface.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
sortType (Auto Sort Type) Specifies the type of sort that is applied to this field.

The possible values for this attribute are defined by the ST_FieldSortType simple type (§18.18.28).
stdDevPSubtotal (StdDevP Subtotal) Specifies a boolean value that indicates whether to apply the 'stdDevP' aggregation function in the subtotal of this field.

A value of 1 or true indicates that the 'stdDevP' aggregation function is applied in the subtotal for this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
stdDevSubtotal (StdDev Subtotal) Specifies a boolean value that indicates whether to use 'stdDev' in the subtotal of this field.

A value of 1 or true indicates that the 'stdDev' aggregation function is applied in the subtotal for this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal for this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
subtotalCaption (Custom Subtotal Caption) Specifies the custom text that is displayed for the subtotals label.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).
subtotalTop (Subtotals At Top) Specifies a boolean value that indicates whether to display subtotals at the top of the group. Applies only when Outline its true.

A value of 1 or true indicates a subtotal is display at the top of the group.

A value of 0 or false indicates subtotal will not be displayed at the top of the group.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
sumSubtotal (Sum Subtotal) Specifies a boolean value that indicates whether apply the 'sum' aggregation function in the subtotal of this field.

A value of 1 or true indicates the 'sum' aggregation function is applied in the subtotal of this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal of this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
topAutoShow (Top Auto Show) Specifies a boolean value that indicates whether an AutoShow filter applied to this field is set to show the top ranked values.

A value of 1 or true indicates whether an AutoShow filter will show top values for this field.

A value of 0 or false indicates bottom ranked values are shown.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
uniqueMemberProperty (Unique Member Property) Specifies the unique name of the member property to be used as a caption for the field and field items.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).
varPSubtotal (VarP Subtotal) Specifies a boolean value that indicates whether to apply the 'varP' aggregation function in the subtotal of this field.

A value of 1 or true indicates the 'varP' aggregation function is applied in the subtotal of this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal of this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.
varSubtotal (Variance Subtotal) Specifies a boolean value that indicates whether to apply the 'variance' aggregation function in the subtotal of this field.

A value of 1 or true indicates the 'variance' aggregation function is applied in the subtotal of this field.

A value of 0 or false indicates another aggregation function is applied in the subtotal of this field.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

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

� ISO/IEC29500: 2008.

Constructors

PivotField()

Initializes a new instance of the PivotField class.

PivotField(IEnumerable<OpenXmlElement>)

Initializes a new instance of the PivotField class with the specified child elements.

PivotField(OpenXmlElement[])

Initializes a new instance of the PivotField class with the specified child elements.

PivotField(String)

Initializes a new instance of the PivotField class from outer XML.

Properties

AllDrilled

All Items Expanded

Represents the following attribute in the schema: allDrilled

ApplyProductInSubtotal

Product Subtotal

Represents the following attribute in the schema: productSubtotal

ApplyStandardDeviationInSubtotal

StdDev Subtotal

Represents the following attribute in the schema: stdDevSubtotal

ApplyStandardDeviationPInSubtotal

StdDevP Subtotal

Represents the following attribute in the schema: stdDevPSubtotal

ApplyVarianceInSubtotal

Variance Subtotal

Represents the following attribute in the schema: varSubtotal

ApplyVariancePInSubtotal

VarP Subtotal

Represents the following attribute in the schema: varPSubtotal

AutoShow

Auto Show

Represents the following attribute in the schema: autoShow

AutoSortScope

AutoSort Scope.

Represents the following element tag in the schema: x:autoSortScope.

AverageSubTotal

Average

Represents the following attribute in the schema: avgSubtotal

Axis

Axis

Represents the following attribute in the schema: axis

ChildElements

Gets all the child nodes of the current element.

(Inherited from OpenXmlElement)
Compact

Compact

Represents the following attribute in the schema: compact

CountASubtotal

CountA

Represents the following attribute in the schema: countASubtotal

CountSubtotal

Count

Represents the following attribute in the schema: countSubtotal

DataField

Data Field

Represents the following attribute in the schema: dataField

DataSourceSort

Data Source Sort

Represents the following attribute in the schema: dataSourceSort

DefaultAttributeDrillState

Drill State

Represents the following attribute in the schema: defaultAttributeDrillState

DefaultSubtotal

Show Default Subtotal

Represents the following attribute in the schema: defaultSubtotal

DragOff

Drag Off

Represents the following attribute in the schema: dragOff

DragToColumn

Drag To Column

Represents the following attribute in the schema: dragToCol

DragToData

Field Can Drag to Data

Represents the following attribute in the schema: dragToData

DragToPage

Drag Field to Page

Represents the following attribute in the schema: dragToPage

DragToRow

Drag To Row

Represents the following attribute in the schema: dragToRow

ExtendedAttributes

Gets all extended attributes (attributes not defined in the schema) of the current element.

(Inherited from OpenXmlElement)
Features

Gets a IFeatureCollection for the current element. This feature collection will be read-only, but will inherit features from its parent part and package if available.

(Inherited from OpenXmlElement)
FirstChild

Gets the first child of the current OpenXmlElement element.

(Inherited from OpenXmlCompositeElement)
HasAttributes

Gets a value indicating whether the current element has any attributes.

(Inherited from OpenXmlElement)
HasChildren

Gets a value that indicates whether the current element has any child elements.

(Inherited from OpenXmlCompositeElement)
HiddenLevel

Hidden Level

Represents the following attribute in the schema: hiddenLevel

HideNewItems

Hide New Items

Represents the following attribute in the schema: hideNewItems

IncludeNewItemsInFilter

Inclusive Manual Filter

Represents the following attribute in the schema: includeNewItemsInFilter

InnerText

Gets or sets the concatenated values of the current node and all of its children.

(Inherited from OpenXmlCompositeElement)
InnerXml

Gets or sets the markup that represents only the child nodes of the current node.

(Inherited from OpenXmlCompositeElement)
InsertBlankRow

Insert Blank Row

Represents the following attribute in the schema: insertBlankRow

InsertPageBreak

Insert Item Page Break

Represents the following attribute in the schema: insertPageBreak

ItemPageCount

Items Per Page Count

Represents the following attribute in the schema: itemPageCount

Items

Field Items.

Represents the following element tag in the schema: x:items.

LastChild

Gets the last child of the current OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no such OpenXmlElement element.

(Inherited from OpenXmlCompositeElement)
LocalName
LocalName

Gets the local name of the current element.

(Inherited from OpenXmlElement)
MaxSubtotal

Max Subtotal

Represents the following attribute in the schema: maxSubtotal

MCAttributes

Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.

(Inherited from OpenXmlElement)
MeasureFilter

Measure Filter

Represents the following attribute in the schema: measureFilter

MinSubtotal

Min Subtotal

Represents the following attribute in the schema: minSubtotal

MultipleItemSelectionAllowed

Multiple Field Filters

Represents the following attribute in the schema: multipleItemSelectionAllowed

Name

Field Name

Represents the following attribute in the schema: name

NamespaceDeclarations

Gets all the namespace declarations defined in the current element. Returns an empty enumerator if there is no namespace declaration.

(Inherited from OpenXmlElement)
NamespaceUri

Gets the namespace URI of the current element.

(Inherited from OpenXmlElement)
NonAutoSortDefault

Auto Sort

Represents the following attribute in the schema: nonAutoSortDefault

NumberFormatId

Number Format Id

Represents the following attribute in the schema: numFmtId

OpenXmlElementContext

Gets the OpenXmlElementContext of the current element.

(Inherited from OpenXmlElement)
OuterXml

Gets the markup that represents the current element and all of its child elements.

(Inherited from OpenXmlElement)
Outline

Outline Items

Represents the following attribute in the schema: outline

Parent

Gets the parent element of the current element.

(Inherited from OpenXmlElement)
PivotFieldExtensionList

Future Feature Data Storage Area.

Represents the following element tag in the schema: x:extLst.

Prefix

Gets the namespace prefix of current element.

(Inherited from OpenXmlElement)
RankBy

Auto Show Rank By

Represents the following attribute in the schema: rankBy

ServerField

Server-based Page Field

Represents the following attribute in the schema: serverField

ShowAll

Show All Items

Represents the following attribute in the schema: showAll

ShowDropDowns

Show PivotField Header Drop Downs

Represents the following attribute in the schema: showDropDowns

ShowPropAsCaption

Show As Caption

Represents the following attribute in the schema: showPropAsCaption

ShowPropCell

Show Member Property in Cell

Represents the following attribute in the schema: showPropCell

ShowPropertyTooltip

Show Member Property ToolTip

Represents the following attribute in the schema: showPropTip

SortType

Auto Sort Type

Represents the following attribute in the schema: sortType

SubtotalCaption

Custom Subtotal Caption

Represents the following attribute in the schema: subtotalCaption

SubtotalTop

Subtotals At Top

Represents the following attribute in the schema: subtotalTop

SumSubtotal

Sum Subtotal

Represents the following attribute in the schema: sumSubtotal

TopAutoShow

Top Auto Show

Represents the following attribute in the schema: topAutoShow

UniqueMemberProperty

Unique Member Property

Represents the following attribute in the schema: uniqueMemberProperty

XmlQualifiedName

Gets the qualified name of the current element.

(Inherited from OpenXmlElement)
XName

Gets the qualified name of the current element.

(Inherited from OpenXmlElement)

Methods

AddAnnotation(Object)

Adds an object to the current OpenXmlElement element's list of annotations.

(Inherited from OpenXmlElement)
AddChild(OpenXmlElement, Boolean)

Adds the specified element to the element if it is a known child. This adds the element in the correct location according to the schema.

(Inherited from OpenXmlCompositeElement)
AddNamespaceDeclaration(String, String)

Adds a namespace declaration to the current node.

(Inherited from OpenXmlElement)
Ancestors()

Enumerates all of the current element's ancestors.

(Inherited from OpenXmlElement)
Ancestors<T>()

Enumerates only the current element's ancestors that have the specified type.

(Inherited from OpenXmlElement)
Annotation(Type)

Get the first annotation object of the specified type from the current OpenXmlElement element.

(Inherited from OpenXmlElement)
Annotation<T>()

Get the first annotation object of the specified type from the current OpenXmlElement element.

(Inherited from OpenXmlElement)
Annotations(Type)

Gets a collection of annotations with the specified type for the current OpenXmlElement element.

(Inherited from OpenXmlElement)
Annotations<T>()

Gets a collection of annotations with the specified type for the current OpenXmlElement element.

(Inherited from OpenXmlElement)
Append(IEnumerable<OpenXmlElement>)

Appends each element from a list of elements to the end of the current element's list of child elements.

(Inherited from OpenXmlElement)
Append(OpenXmlElement[])

Appends each element from an array of elements to the end of the current element's list of child elements.

(Inherited from OpenXmlElement)
AppendChild<T>(T)

Appends the specified element to the end of the current element's list of child nodes.

(Inherited from OpenXmlCompositeElement)
ClearAllAttributes()

Clears all of the attributes, including both known attributes and extended attributes.

(Inherited from OpenXmlElement)
Clone()

Creates a duplicate of the current node.

(Inherited from OpenXmlElement)
CloneNode(Boolean)

Creates a duplicate of this node.

Descendants()

Enumerates all of the current element's descendants.

(Inherited from OpenXmlElement)
Descendants<T>()

Enumerate all of the current element's descendants of type T.

(Inherited from OpenXmlElement)
Elements()

Enumerates all of the current element's children.

(Inherited from OpenXmlElement)
Elements<T>()

Enumerates only the current element's children that have the specified type.

(Inherited from OpenXmlElement)
ElementsAfter()

Enumerates all of the sibling elements that follow the current element and have the same parent as the current element.

(Inherited from OpenXmlElement)
ElementsBefore()

Enumerates all of the sibling elements that precede the current element and have the same parent as the current element.

(Inherited from OpenXmlElement)
GetAttribute(String, String)

Gets an Open XML attribute with the specified tag name and namespace URI.

(Inherited from OpenXmlElement)
GetAttributes()

Gets a list that contains a copy of all the attributes.

(Inherited from OpenXmlElement)
GetEnumerator()

Returns an enumerator that iterates through the child collection.

(Inherited from OpenXmlElement)
GetFirstChild<T>()

Finds the first child element in type T.

(Inherited from OpenXmlElement)
InsertAfter<T>(T, OpenXmlElement)

Inserts the specified element immediately after the specified reference element.

(Inherited from OpenXmlCompositeElement)
InsertAfterSelf<T>(T)

Inserts the specified element immediately after the current element.

(Inherited from OpenXmlElement)
InsertAt<T>(T, Int32)

Inserts the specified element at the specified index of the current element's children.

(Inherited from OpenXmlCompositeElement)
InsertBefore<T>(T, OpenXmlElement)

Inserts the specified element immediately before the specified reference element.

(Inherited from OpenXmlCompositeElement)
InsertBeforeSelf<T>(T)

Inserts the specified element immediately before the current element.

(Inherited from OpenXmlElement)
IsAfter(OpenXmlElement)

Determines if the current element appears after a specified element in document order.

(Inherited from OpenXmlElement)
IsBefore(OpenXmlElement)

Determines if the current element appears before a specified element in document order.

(Inherited from OpenXmlElement)
LookupNamespace(String)

Resolves the namespace prefix in the context of the current node.

(Inherited from OpenXmlElement)
LookupPrefix(String)

Finds the corresponding prefix for a namespace uri in the current element scope.

(Inherited from OpenXmlElement)
NextSibling()

Gets the OpenXmlElement element that immediately follows the current OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no next OpenXmlElement element.

(Inherited from OpenXmlElement)
NextSibling<T>()

Gets the OpenXmlElement element with the specified type that follows the current OpenXmlElement element. Returns null (Nothing in Visual Basic) if there is no next OpenXmlElement.

(Inherited from OpenXmlElement)
PrependChild<T>(T)

Inserts the specified element at the beginning of the current element's list of child nodes.

(Inherited from OpenXmlCompositeElement)
PreviousSibling()

Gets the OpenXmlElement element that immediately precedes the current OpenXmlElement element. Returns null (Nothing in Visual Basic ) if there is no preceding OpenXmlElement element.

(Inherited from OpenXmlElement)
PreviousSibling<T>()

Gets the OpenXmlElement element with the specified type that precedes the current OpenXmlElement. Returns null (Nothing in Visual Basic) if there is no preceding OpenXmlElement element.

(Inherited from OpenXmlElement)
Remove()

Removes the current element from its parent.

(Inherited from OpenXmlElement)
RemoveAllChildren()

Removes all of the current element's child elements.

(Inherited from OpenXmlCompositeElement)
RemoveAllChildren<T>()

Remove all of the current element's child elements that are of type T.

(Inherited from OpenXmlElement)
RemoveAnnotations(Type)

Removes the annotations of the specified type from the current OpenXmlElement element.

(Inherited from OpenXmlElement)
RemoveAnnotations<T>()

Removes the annotations with the specified type from the current OpenXmlElement element.

(Inherited from OpenXmlElement)
RemoveAttribute(String, String)

Removes the attribute from the current element.

(Inherited from OpenXmlElement)
RemoveChild<T>(T)

Removes the specified child element.

(Inherited from OpenXmlCompositeElement)
RemoveNamespaceDeclaration(String)

Removes the namespace declaration for the specified prefix. Removes nothing if there is no prefix.

(Inherited from OpenXmlElement)
ReplaceChild<T>(OpenXmlElement, T)

Replaces one of the current element's child elements with another OpenXmlElement element.

(Inherited from OpenXmlCompositeElement)
SetAttribute(OpenXmlAttribute)

Sets an attribute to the specified element. If the attribute is a known attribute, the value of the attribute is set. If the attribute is an extended attribute, the 'openxmlAttribute' is added to the extended attributes list.

(Inherited from OpenXmlElement)
SetAttributes(IEnumerable<OpenXmlAttribute>)

Sets a number of attributes to the element. If an attribute is a known attribute, the value of the attribute is set. If an attribute is an extended attribute, the 'openxmlAttribute' is added to the extended attributes list.

(Inherited from OpenXmlElement)
WriteTo(XmlWriter)

Saves the current node to the specified XmlWriter.

(Inherited from OpenXmlElement)

Explicit Interface Implementations

IEnumerable.GetEnumerator() (Inherited from OpenXmlElement)
IEnumerable<OpenXmlElement>.GetEnumerator()

Returns an enumerator that iterates through the child collection.

(Inherited from OpenXmlElement)

Applies to