PivotTableDefinition Properties

Include Protected Members
Include Inherited Members

The PivotTableDefinition type exposes the following members.

Properties

	Name	Description
	ApplyAlignmentFormats	Apply Alignment Formats.Represents the attribte in schema: applyAlignmentFormats
	ApplyBorderFormats	Apply Border Formats.Represents the attribte in schema: applyBorderFormats
	ApplyFontFormats	Apply Font Formats.Represents the attribte in schema: applyFontFormats
	ApplyNumberFormats	Apply Number Formats.Represents the attribte in schema: applyNumberFormats
	ApplyPatternFormats	Apply Pattern Formats.Represents the attribte in schema: applyPatternFormats
	ApplyWidthHeightFormats	Apply Width / Height Formats.Represents the attribte in schema: applyWidthHeightFormats
	AsteriskTotals	Asterisk Totals.Represents the attribte in schema: asteriskTotals
	AutoFormatId	Auto Format Id.Represents the attribte in schema: autoFormatId
	CacheId	PivotCache Definition Id.Represents the attribte in schema: cacheId
	ChartFormat	Chart Format Id.Represents the attribte in schema: chartFormat
	ChartFormats	PivotChart Formats.Represents the element tag in schema: x:chartFormats
	ChildElements	Gets all the child nodes of this element. (Inherited from OpenXmlElement.)
	ColumnFields	Column Fields.Represents the element tag in schema: x:colFields
	ColumnGrandTotals	Grand Totals On Columns.Represents the attribte in schema: colGrandTotals
	ColumnHeaderCaption	Column Header Caption.Represents the attribte in schema: colHeaderCaption
	ColumnHierarchiesUsage	Column OLAP Hierarchy References.Represents the element tag in schema: x:colHierarchiesUsage
	ColumnItems	Column Items.Represents the element tag in schema: x:colItems
	Compact	Compact New Fields.Represents the attribte in schema: compact
	CompactData	Compact Data.Represents the attribte in schema: compactData
	ConditionalFormats	Conditional Formats.Represents the element tag in schema: x:conditionalFormats
	CreatedVersion	PivotCache Created Version.Represents the attribte in schema: createdVersion
	CustomListSort	Custom List AutoSort.Represents the attribte in schema: customListSort
	DataCaption	Data Field Header Name.Represents the attribte in schema: dataCaption
	DataFields	Data Fields.Represents the element tag in schema: x:dataFields
	DataOnRows	Data On Rows.Represents the attribte in schema: dataOnRows
	DataPosition	Default Data Field Position.Represents the attribte in schema: dataPosition
	DisableFieldList	Disable Field List.Represents the attribte in schema: disableFieldList
	EditData	Allow Edit Data.Represents the attribte in schema: editData
	EnableDrill	Enable Drill Down.Represents the attribte in schema: enableDrill
	EnableFieldProperties	Enable Field Properties.Represents the attribte in schema: enableFieldProperties
	EnableWizard	Enable PivotTable Wizard.Represents the attribte in schema: enableWizard
	ErrorCaption	Error Caption.Represents the attribte in schema: errorCaption
	ExtendedAttributes	Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.)
	FieldListSortAscending	Default Sort Order.Represents the attribte in schema: fieldListSortAscending
	FieldPrintTitles	Field Print Titles.Represents the attribte in schema: fieldPrintTitles
	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.)
	Formats	PivotTable Formats.Represents the element tag in schema: x:formats
	GrandTotalCaption	Grand Totals Caption.Represents the attribte in schema: grandTotalCaption
	GridDropZones	Enable Drop Zones.Represents the attribte in schema: gridDropZones
	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.)
	Indent	Indentation for Compact Axis.Represents the attribte in schema: indent
	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.)
	ItemPrintTitles	Item Print Titles.Represents the attribte in schema: itemPrintTitles
	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.)
	Location	PivotTable Location.Represents the element tag in schema: x:location
	MCAttributes	Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.)
	MergeItem	Merge Titles.Represents the attribte in schema: mergeItem
	MinRefreshableVersion	Minimum Refreshable Version.Represents the attribte in schema: minRefreshableVersion
	MissingCaption	Caption for Missing Values.Represents the attribte in schema: missingCaption
	MultipleFieldFilters	Multiple Field Filters.Represents the attribte in schema: multipleFieldFilters
	Name	Name.Represents the attribte in schema: name
	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.)
	Outline	Outline New Fields.Represents the attribte in schema: outline
	OutlineData	Outline Data Fields.Represents the attribte in schema: outlineData
	PageFields	Page Field Items.Represents the element tag in schema: x:pageFields
	PageOverThenDown	Page Over Then Down.Represents the attribte in schema: pageOverThenDown
	PageStyle	Page Header Style Name.Represents the attribte in schema: pageStyle
	PageWrap	Page Wrap.Represents the attribte in schema: pageWrap
	Parent	Gets the parent of this element. (Inherited from OpenXmlElement.)
	PivotFields	PivotTable Fields.Represents the element tag in schema: x:pivotFields
	PivotFilters	Filters.Represents the element tag in schema: x:filters
	PivotHierarchies	PivotTable OLAP Hierarchies.Represents the element tag in schema: x:pivotHierarchies
	PivotTableDefinitionExtensionList	Future Feature Data Storage Area.Represents the element tag in schema: x:extLst
	PivotTablePart	Gets the PivotTablePart associated with this element.
	PivotTableStyle	PivotTable Style.Represents the element tag in schema: x:pivotTableStyleInfo
	PivotTableStyleName	Table Style Name.Represents the attribte in schema: pivotTableStyle
	Prefix	Gets the namespace prefix of this node. (Inherited from OpenXmlElement.)
	PreserveFormatting	Preserve Formatting.Represents the attribte in schema: preserveFormatting
	PrintDrill	Print Drill Indicators.Represents the attribte in schema: printDrill
	Published	Data Fields Published.Represents the attribte in schema: published
	RowFields	Row Fields.Represents the element tag in schema: x:rowFields
	RowGrandTotals	Row Grand Totals.Represents the attribte in schema: rowGrandTotals
	RowHeaderCaption	Row Header Caption.Represents the attribte in schema: rowHeaderCaption
	RowHierarchiesUsage	Row OLAP Hierarchy References.Represents the element tag in schema: x:rowHierarchiesUsage
	RowItems	Row Items.Represents the element tag in schema: x:rowItems
	ShowCalculatedMembers	Show Calculated Members.Represents the attribte in schema: showCalcMbrs
	ShowDataDropDown	Show Drop Down.Represents the attribte in schema: showDataDropDown
	ShowDataTips	Show ToolTips on Data.Represents the attribte in schema: showDataTips
	ShowDrill	Show Expand Collapse.Represents the attribte in schema: showDrill
	ShowDropZones	Show Drop Zones.Represents the attribte in schema: showDropZones
	ShowEmptyColumn	Show Empty Column.Represents the attribte in schema: showEmptyCol
	ShowEmptyRow	Show Empty Row.Represents the attribte in schema: showEmptyRow
	ShowError	Show Error.Represents the attribte in schema: showError
	ShowHeaders	Show Field Headers.Represents the attribte in schema: showHeaders
	ShowItems	Show Item Names.Represents the attribte in schema: showItems
	ShowMemberPropertyTips	Show Member Property ToolTips.Represents the attribte in schema: showMemberPropertyTips
	ShowMissing	Show Missing.Represents the attribte in schema: showMissing
	ShowMultipleLabel	Show Multiple Labels.Represents the attribte in schema: showMultipleLabel
	StopImmersiveUi	Stop Immersive UI.Represents the attribte in schema: immersive
	SubtotalHiddenItems	Subtotal Hidden Items.Represents the attribte in schema: subtotalHiddenItems
	Tag	PivotTable Custom String.Represents the attribte in schema: tag
	UpdatedVersion	PivotTable Last Updated Version.Represents the attribte in schema: updatedVersion
	UseAutoFormatting	Auto Formatting.Represents the attribte in schema: useAutoFormatting
	VacatedStyle	Vacated Style.Represents the attribte in schema: vacatedStyle
	VisualTotals	Total Visual Data.Represents the attribte in schema: visualTotals
	XmlQualifiedName	Gets the qualified name of the node. (Inherited from OpenXmlElement.)

Top

See Also

Reference

PivotTableDefinition Class

DocumentFormat.OpenXml.Spreadsheet Namespace