 | Pivot |
The PivotTableDefinition type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | ApplyAlignmentFormats | Apply Alignment Formats Represents the following attribute in the schema: applyAlignmentFormats |
| ApplyBorderFormats | Apply Border Formats Represents the following attribute in the schema: applyBorderFormats |
| ApplyFontFormats | Apply Font Formats Represents the following attribute in the schema: applyFontFormats |
| ApplyNumberFormats | Apply Number Formats Represents the following attribute in the schema: applyNumberFormats |
| ApplyPatternFormats | Apply Pattern Formats Represents the following attribute in the schema: applyPatternFormats |
| ApplyWidthHeightFormats | Apply Width / Height Formats Represents the following attribute in the schema: applyWidthHeightFormats |
| AsteriskTotals | asteriskTotals Represents the following attribute in the schema: asteriskTotals |
| AutoFormatId | Auto Format Id Represents the following attribute in the schema: autoFormatId |
| CacheId | cacheId Represents the following attribute in the schema: cacheId |
| ChartFormat | chartFormat Represents the following attribute in the schema: chartFormat |
| ChartFormats | ChartFormats. Represents the following element tag in the schema: x:chartFormats. |
| ChildElements |
Gets all the child nodes of the current element.
(Inherited from OpenXmlElement) |
| ColumnFields | ColumnFields. Represents the following element tag in the schema: x:colFields. |
| ColumnGrandTotals | colGrandTotals Represents the following attribute in the schema: colGrandTotals |
| ColumnHeaderCaption | colHeaderCaption Represents the following attribute in the schema: colHeaderCaption |
| ColumnHierarchiesUsage | ColumnHierarchiesUsage. Represents the following element tag in the schema: x:colHierarchiesUsage. |
| ColumnItems | ColumnItems. Represents the following element tag in the schema: x:colItems. |
| Compact | compact Represents the following attribute in the schema: compact |
| CompactData | compactData Represents the following attribute in the schema: compactData |
| ConditionalFormats | ConditionalFormats. Represents the following element tag in the schema: x:conditionalFormats. |
| CreatedVersion | createdVersion Represents the following attribute in the schema: createdVersion |
| CustomListSort | customListSort Represents the following attribute in the schema: customListSort |
| DataCaption | dataCaption Represents the following attribute in the schema: dataCaption |
| DataFields | DataFields. Represents the following element tag in the schema: x:dataFields. |
| DataOnRows | dataOnRows Represents the following attribute in the schema: dataOnRows |
| DataPosition | dataPosition Represents the following attribute in the schema: dataPosition |
| DisableFieldList | disableFieldList Represents the following attribute in the schema: disableFieldList |
| EditData | editData Represents the following attribute in the schema: editData |
| EnableDrill | enableDrill Represents the following attribute in the schema: enableDrill |
| EnableFieldProperties | enableFieldProperties Represents the following attribute in the schema: enableFieldProperties |
| EnableWizard | enableWizard Represents the following attribute in the schema: enableWizard |
| ErrorCaption | errorCaption Represents the following attribute in the schema: errorCaption |
| 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) |
| FieldListSortAscending | fieldListSortAscending Represents the following attribute in the schema: fieldListSortAscending |
| FieldPrintTitles | fieldPrintTitles Represents the following attribute in the schema: fieldPrintTitles |
| FirstChild |
Gets the first child of the current OpenXmlElement element.
(Inherited from OpenXmlCompositeElement) |
| Formats | Formats. Represents the following element tag in the schema: x:formats. |
| GrandTotalCaption | grandTotalCaption Represents the following attribute in the schema: grandTotalCaption |
| GridDropZones | gridDropZones Represents the following attribute in the schema: gridDropZones |
| 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) |
| Indent | indent Represents the following attribute in the schema: indent |
| 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) |
| ItemPrintTitles | itemPrintTitles Represents the following attribute in the schema: itemPrintTitles |
| 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) |
| Location | Location. Represents the following element tag in the schema: x:location. |
| MCAttributes |
Gets or sets the markup compatibility attributes. Returns null if no markup compatibility attributes are defined for the current element.
(Inherited from OpenXmlElement) |
| MdxSubqueries | mdxSubqueries Represents the following attribute in the schema: mdxSubqueries |
| MergeItem | mergeItem Represents the following attribute in the schema: mergeItem |
| MinRefreshableVersion | minRefreshableVersion Represents the following attribute in the schema: minRefreshableVersion |
| MissingCaption | missingCaption Represents the following attribute in the schema: missingCaption |
| MultipleFieldFilters | multipleFieldFilters Represents the following attribute in the schema: multipleFieldFilters |
| Name | 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) |
| 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 Represents the following attribute in the schema: outline |
| OutlineData | outlineData Represents the following attribute in the schema: outlineData |
| PageFields | PageFields. Represents the following element tag in the schema: x:pageFields. |
| PageOverThenDown | pageOverThenDown Represents the following attribute in the schema: pageOverThenDown |
| PageStyle | pageStyle Represents the following attribute in the schema: pageStyle |
| PageWrap | pageWrap Represents the following attribute in the schema: pageWrap |
| Parent |
Gets the parent element of the current element.
(Inherited from OpenXmlElement) |
| PivotFields | PivotFields. Represents the following element tag in the schema: x:pivotFields. |
| PivotFilters | PivotFilters. Represents the following element tag in the schema: x:filters. |
| PivotHierarchies | PivotHierarchies. Represents the following element tag in the schema: x:pivotHierarchies. |
| PivotTableDefinitionExtensionList | PivotTableDefinitionExtensionList. Represents the following element tag in the schema: x:extLst. |
| PivotTablePart | Gets the PivotTablePart associated with this element. |
| PivotTableStyle | PivotTableStyle. Represents the following element tag in the schema: x:pivotTableStyleInfo. |
| PivotTableStyleName | pivotTableStyle Represents the following attribute in the schema: pivotTableStyle |
| Prefix |
Gets the namespace prefix of current element.
(Inherited from OpenXmlElement) |
| PreserveFormatting | preserveFormatting Represents the following attribute in the schema: preserveFormatting |
| PrintDrill | printDrill Represents the following attribute in the schema: printDrill |
| Published | published Represents the following attribute in the schema: published |
| RowFields | RowFields. Represents the following element tag in the schema: x:rowFields. |
| RowGrandTotals | rowGrandTotals Represents the following attribute in the schema: rowGrandTotals |
| RowHeaderCaption | rowHeaderCaption Represents the following attribute in the schema: rowHeaderCaption |
| RowHierarchiesUsage | RowHierarchiesUsage. Represents the following element tag in the schema: x:rowHierarchiesUsage. |
| RowItems | RowItems. Represents the following element tag in the schema: x:rowItems. |
| ShowCalculatedMembers | showCalcMbrs Represents the following attribute in the schema: showCalcMbrs |
| ShowDataDropDown | showDataDropDown Represents the following attribute in the schema: showDataDropDown |
| ShowDataTips | showDataTips Represents the following attribute in the schema: showDataTips |
| ShowDrill | showDrill Represents the following attribute in the schema: showDrill |
| ShowDropZones | showDropZones Represents the following attribute in the schema: showDropZones |
| ShowEmptyColumn | showEmptyCol Represents the following attribute in the schema: showEmptyCol |
| ShowEmptyRow | showEmptyRow Represents the following attribute in the schema: showEmptyRow |
| ShowError | showError Represents the following attribute in the schema: showError |
| ShowHeaders | showHeaders Represents the following attribute in the schema: showHeaders |
| ShowItems | showItems Represents the following attribute in the schema: showItems |
| ShowMemberPropertyTips | showMemberPropertyTips Represents the following attribute in the schema: showMemberPropertyTips |
| ShowMissing | showMissing Represents the following attribute in the schema: showMissing |
| ShowMultipleLabel | showMultipleLabel Represents the following attribute in the schema: showMultipleLabel |
| StopImmersiveUi | immersive Represents the following attribute in the schema: immersive |
| SubtotalHiddenItems | subtotalHiddenItems Represents the following attribute in the schema: subtotalHiddenItems |
| Tag | tag Represents the following attribute in the schema: tag |
| UpdatedVersion | updatedVersion Represents the following attribute in the schema: updatedVersion |
| UseAutoFormatting | useAutoFormatting Represents the following attribute in the schema: useAutoFormatting |
| VacatedStyle | vacatedStyle Represents the following attribute in the schema: vacatedStyle |
| VisualTotals | visualTotals Represents the following attribute in the schema: visualTotals |
| XmlQualifiedName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) |
| XName |
Gets the qualified name of the current element.
(Inherited from OpenXmlElement) |
See Also