PivotTableDefinition Members
Include Protected Members
Include Inherited Members
Defines the PivotTableDefinition Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:pivotTableDefinition.
The PivotTableDefinition type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Public method") |
PivotTableDefinition() | Initializes a new instance of the PivotTableDefinition class. |
|
PivotTableDefinition(String) | Initializes a new instance of the PivotTableDefinition class from outer XML. |
|
PivotTableDefinition(array<OpenXmlElement[]) | Initializes a new instance of the PivotTableDefinition class with the specified child elements. |
|
PivotTableDefinition(IEnumerable<OpenXmlElement>) | Initializes a new instance of the PivotTableDefinition class with the specified child elements. |
Top
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
AllocationMethod | allocationMethod.Represents the attribte in schema: allocationMethod |
|
AltText | altText.Represents the attribte in schema: altText |
|
AltTextSummary | altTextSummary.Represents the attribte in schema: altTextSummary |
|
AutoApply | autoApply.Represents the attribte in schema: autoApply |
|
CalculatedMembersInFilters | calculatedMembersInFilters.Represents the attribte in schema: calculatedMembersInFilters |
|
ChildElements | Gets all the child nodes of this element. (Inherited from OpenXmlElement.) |
|
ConditionalFormats | ConditionalFormats.Represents the element tag in schema: x14:conditionalFormats |
|
EnableEdit | enableEdit.Represents the attribte in schema: enableEdit |
|
ExtendedAttributes | Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.) |
|
FillDownLabelsDefault | fillDownLabelsDefault.Represents the attribte in schema: fillDownLabelsDefault |
|
FirstChild | Gets the first child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.) |
|
HasAttributes | Gets a boolean value indicating whether the current element has any attributes. (Inherited from OpenXmlElement.) |
|
HasChildren | Gets a value indicating whether this element has any child elements. (Inherited from OpenXmlCompositeElement.) |
|
HideValuesRow | hideValuesRow.Represents the attribte in schema: hideValuesRow |
|
InnerText | Gets or sets the concatenated values of the node and all its children. (Inherited from OpenXmlCompositeElement.) |
|
InnerXml | Gets or sets the markup representing only the child nodes of this node. (Inherited from OpenXmlCompositeElement.) |
|
LastChild | Gets the last child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.) |
|
LocalName | Gets the local name of the element. (Overrides OpenXmlElement.LocalName.) |
|
MCAttributes | Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.) |
|
NamespaceDeclarations | Gets all the namespace declarations defined in the current element. Return an empty enumerator if there is no namespace declaration. (Inherited from OpenXmlElement.) |
|
NamespaceUri | Gets the namespace URI of this node. (Inherited from OpenXmlElement.) |
|
OpenXmlElementContext | Gets the OpenXmlEementContext. (Inherited from OpenXmlElement.) |
|
OuterXml | Gets the markup representing this element and all its child elements. (Inherited from OpenXmlElement.) |
|
Parent | Gets the parent of this element. (Inherited from OpenXmlElement.) |
|
PivotChanges | PivotChanges.Represents the element tag in schema: x14:pivotChanges |
|
PivotEdits | PivotEdits.Represents the element tag in schema: x14:pivotEdits |
|
Prefix | Gets the namespace prefix of this node. (Inherited from OpenXmlElement.) |
|
VisualTotalsForSets | visualTotalsForSets.Represents the attribte in schema: visualTotalsForSets |
|
WeightExpression | weightExpression.Represents the attribte in schema: weightExpression |
|
XmlQualifiedName | Gets the qualified name of the node. (Inherited from OpenXmlElement.) |
Top
Methods
| Name | Description | |
|---|---|---|
|
AddAnnotation | Adds an object to the annotation list of this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
AddNamespaceDeclaration | Adds a namepace declaration to the current node. (Inherited from OpenXmlElement.) |
|
Ancestors() | Enumerate all the ancestor nodes of this element. (Inherited from OpenXmlElement.) |
|
Annotation(Type) | Get the first annotation object of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
Annotation<T>() | Get the first annotation object of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
Annotations(Type) | Gets a collection of annotations of the specified type for this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
Annotations<T>() | Gets a collection of annotations of the specified type for this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
Append(array<OpenXmlElement[]) | Adds the elements to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.) |
|
Append(IEnumerable<OpenXmlElement>) | Adds the elements to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.) |
|
AppendChild<T>(T) | Adds the specified element to the end of the list of child nodes, of this element. (Inherited from OpenXmlCompositeElement.) |
|
AppendChild<T>(T) | Adds the specified element to the end of the list of child nodes, of this element. (Inherited from OpenXmlElement.) |
|
ClearAllAttributes | Clear all the attributes ( known attributes + extended attributes ) (Inherited from OpenXmlElement.) |
|
Clone | Creates a duplicate of this node. (Inherited from OpenXmlElement.) |
|
CloneNode | Creates a duplicate of this node. (Overrides OpenXmlElement.CloneNode(Boolean).) |
|
Descendants<T>() | Enumerate all the descendants elements (which type is T) of this element. Preorder traversering. (Inherited from OpenXmlElement.) |
|
Elements<T>() | Enumerate for specific type of elements in child elements (Inherited from OpenXmlElement.) |
|
ElementsAfter | Enumerate all the sibling elements after this element in same parent. (Inherited from OpenXmlElement.) |
|
ElementsBefore | Enumerate all the sibling elements before this element in same parent. (Inherited from OpenXmlElement.) |
|
Equals | (Inherited from Object.) |
.gif "Protected method") |
Finalize | (Inherited from Object.) |
|
GetAttribute | Gets a Open XML attribute with the specifed tag name and namespace URI. (Inherited from OpenXmlElement.) |
|
GetAttributes | Get a copy of all the attributes (Inherited from OpenXmlElement.) |
|
GetEnumerator | Returns an enumerator that iterates through the child collection. (Inherited from OpenXmlElement.) |
|
GetFirstChild<T> | Find the first child element in type T (Inherited from OpenXmlElement.) |
|
GetHashCode | (Inherited from Object.) |
|
GetType | (Inherited from Object.) |
|
InsertAfter<T>(T, OpenXmlElement) | Inserts the specified element immediately after the specified reference element. (Inherited from OpenXmlCompositeElement.) |
|
InsertAfter<T>(T, OpenXmlElement) | Inserts the specified element immediately after the specified reference element. (Inherited from OpenXmlElement.) |
|
InsertAfterSelf<T> | Inserts the specified element immediately after this element. (Inherited from OpenXmlElement.) |
|
InsertAt<T>(T, Int32) | Inserts the specified element at the specified index in children. (Inherited from OpenXmlCompositeElement.) |
|
InsertAt<T>(T, Int32) | Inserts the specified element at the specified index in children. (Inherited from OpenXmlElement.) |
|
InsertBefore<T>(T, OpenXmlElement) | Inserts the specified element immediately before the specified reference element. (Inherited from OpenXmlCompositeElement.) |
|
InsertBefore<T>(T, OpenXmlElement) | Inserts the specified element immediately before the specified reference element. (Inherited from OpenXmlElement.) |
|
InsertBeforeSelf<T> | Inserts the specified element immediately before this element. (Inherited from OpenXmlElement.) |
|
IsAfter | Determines if the current element appears after a specified element in document order. (Inherited from OpenXmlElement.) |
|
IsBefore | Determines if the current element appears before a specified element in document order. (Inherited from OpenXmlElement.) |
|
LookupNamespace | Resolve the namespace prefix in the context of current node (Inherited from OpenXmlElement.) |
|
LookupPrefix | Finds the corresponding prefix for a namespace uri in the current element scope. (Inherited from OpenXmlElement.) |
|
MemberwiseClone | (Inherited from Object.) |
|
NextSibling() | Gets the OpenXmlElement immediately following this OpenXmlElement. If there is no next OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.) |
|
PrependChild<T>(T) | Adds the specified element to the beginning of the list of child nodes for this element. (Inherited from OpenXmlCompositeElement.) |
|
PrependChild<T>(T) | Adds the specified element to the beginning of the list of child nodes for this element. (Inherited from OpenXmlElement.) |
|
PreviousSibling() | Gets the OpenXmlElement immediately preceding this OpenXmlElement. If there is no such preceding OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlElement.) |
|
Remove | Removes this element from its parent. (Inherited from OpenXmlElement.) |
|
RemoveAllChildren | Remove all the child elements (Inherited from OpenXmlCompositeElement.) |
|
RemoveAnnotations(Type) | Removes the annotations of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
RemoveAnnotations<T>() | Removes the annotations of the specified type from this OpenXmlElement. (Inherited from OpenXmlElement.) |
|
RemoveAttribute | Remove the attribute from the element. (Inherited from OpenXmlElement.) |
|
RemoveChild<T>(T) | Removes specified child element. (Inherited from OpenXmlCompositeElement.) |
|
RemoveChild<T>(T) | Removes specified child element. (Inherited from OpenXmlElement.) |
|
RemoveNamespaceDeclaration | Removes namespace declaration for a specific prefix. do nothing if the prefix is not existed. (Inherited from OpenXmlElement.) |
|
ReplaceChild<T>(OpenXmlElement, T) | Replaces the child OpenXmlElement oldChild with newChild OpenXmlElement. (Inherited from OpenXmlCompositeElement.) |
|
ReplaceChild<T>(OpenXmlElement, T) | Replaces the child OpenXmlElement oldChild with newChild OpenXmlElement. (Inherited from OpenXmlElement.) |
|
SetAttribute | Set an attribute to the 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 | Set a bunch of attributes to the element. If a attribute is a known attribute, the value of the attribute is set. If a attribute is an extended attribute, the 'openxmlAttribute' is added to the extended attributes list. (Inherited from OpenXmlElement.) |
|
ToString | (Inherited from Object.) |
|
WriteTo | Saves the current node to the specified XmlWriter. (Inherited from OpenXmlElement.) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
.gif "Explicit interface implemetation") .gif "Private method") |
IEnumerable.GetEnumerator | (Inherited from OpenXmlElement.) |
Top