PivotTableDefinition Members

Include Protected Members
Include Inherited Members

PivotTable Definition. It is the root element of PivotTablePart.

The PivotTableDefinition type exposes the following members.

Constructors

	Name	Description
	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
	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

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.)
	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.)
	Load	Loads the DOM from the PivotTablePart.
	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.)
	Reload	Reloads the part content into Open XML DOM tree. It could be called multiple times and each time it is called, the tree will be reloaded; previous changes on the tree are abandoned. (Inherited from OpenXmlPartRootElement.)
	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.)
	Save()	Saves the data in the DOM tree back to the part. It could be called multiple times as well. Each time it is called, the stream will be flushed. (Inherited from OpenXmlPartRootElement.)
	Save(Stream)	Save the DOM tree to stream. (Inherited from OpenXmlPartRootElement.)
	Save(PivotTablePart)	Saves the DOM into the PivotTablePart.
	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 OpenXmlPartRootElement.)

Top

Explicit Interface Implementations

	Name	Description
	IEnumerable.GetEnumerator	(Inherited from OpenXmlElement.)

Top

See Also

Reference

PivotTableDefinition Class

DocumentFormat.OpenXml.Spreadsheet Namespace