Pivot |
The PivotTableDefinition type exposes the following members.
| Name | Description | |
|---|---|---|
| AllocationMethod | allocationMethod, this property is only available in Office 2010 and later. Represents the following attribute in the schema: allocationMethod | |
| AltText | altText, this property is only available in Office 2010 and later. Represents the following attribute in the schema: altText | |
| AltTextSummary | altTextSummary, this property is only available in Office 2010 and later. Represents the following attribute in the schema: altTextSummary | |
| AutoApply | autoApply, this property is only available in Office 2010 and later. Represents the following attribute in the schema: autoApply | |
| CalculatedMembersInFilters | calculatedMembersInFilters, this property is only available in Office 2010 and later. Represents the following attribute in the schema: calculatedMembersInFilters | |
| ChildElements |
Gets all the child nodes of the current element.
(Inherited from OpenXmlElement) | |
| ConditionalFormats | ConditionalFormats. Represents the following element tag in the schema: x14:conditionalFormats. | |
| EnableEdit | enableEdit, this property is only available in Office 2010 and later. Represents the following attribute in the schema: enableEdit | |
| 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) | |
| FillDownLabelsDefault | fillDownLabelsDefault, this property is only available in Office 2010 and later. Represents the following attribute in the schema: fillDownLabelsDefault | |
| 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 indicating whether the current element has any child elements.
(Inherited from OpenXmlCompositeElement) | |
| HideValuesRow | hideValuesRow, this property is only available in Office 2010 and later. Represents the following attribute in the schema: hideValuesRow | |
| InnerText |
Gets or sets the concatenated values of the node and all of its children.
(Inherited from OpenXmlCompositeElement) | |
| InnerXml |
Gets or sets the markup that represents only the child elements of the current element.
(Inherited from OpenXmlCompositeElement) | |
| 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 |
Gets the local name of the current element.
(Inherited from OpenXmlElement) | |
| MCAttributes |
Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.
(Inherited from OpenXmlElement) | |
| 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) | |
| 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) | |
| Parent |
Gets the parent element of the current element.
(Inherited from OpenXmlElement) | |
| PivotChanges | PivotChanges. Represents the following element tag in the schema: x14:pivotChanges. | |
| PivotEdits | PivotEdits. Represents the following element tag in the schema: x14:pivotEdits. | |
| Prefix |
Gets the namespace prefix of current element.
(Inherited from OpenXmlElement) | |
| VisualTotalsForSets | visualTotalsForSets, this property is only available in Office 2010 and later. Represents the following attribute in the schema: visualTotalsForSets | |
| WeightExpression | weightExpression, this property is only available in Office 2010 and later. Represents the following attribute in the schema: weightExpression | |
| XmlQualifiedName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) | |
| XName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) |