Click or drag to resize

PivotTablesCollection Class

Represents a collection of PivotTable objects in a worksheet, allowing for the management and manipulation of pivot tables.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet.Collections CollectionBase IPivotTable
Spire.Xls.Core.Spreadsheet.Collections CollectionExtended IPivotTable
Spire.Xls.Core.Spreadsheet.Collections XlsPivotTablesCollection
Spire.Xls.Collections PivotTablesCollection

Namespace: Spire.Xls.Collections
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class PivotTablesCollection : XlsPivotTablesCollection

The PivotTablesCollection type exposes the following members.

Properties
Name Description
Public property Capacity
Gets or sets the number of elements that the System.Collections.CollectionBase can contain.
(Inherited from CollectionBase T .)
Public property Count
Returns number of items in the collection.
(Inherited from XlsPivotTablesCollection .)
Protected property InnerList
Gets the list of elements in the instance.
(Inherited from CollectionBase T .)
Public property IsReadOnly
Gets a value indicating whether the collection is read-only.
(Inherited from CollectionBase T .)
Public property Item Int32
Gets single entry from the collection.
(Inherited from XlsPivotTablesCollection .)
Public property Item String
Gets single entry from the collection.
(Inherited from XlsPivotTablesCollection .)
Protected property List
Gets the list of elements in the instance.
(Inherited from CollectionBase T .)
Public property Parent
Read-oonly. The parent object for the specified object.
(Inherited from CollectionExtended T .)
Public property ParentWorksheet
Gets the parent worksheet of the current XlsWorksheetBase instance.
(Inherited from XlsPivotTablesCollection .)
Top
Methods
Name Description
Public method Add(T)
Adds an item to the collection.trigger OnInsert and OnInsertComplete method when set item
(Inherited from CollectionBase T .)
Public method Add(String, CellRange, PivotCache)
Adds new pivot table to the collection.
(Inherited from XlsPivotTablesCollection .)
Public method Clear
Clears the contents of the collection or object, resetting it to its initial state.
(Inherited from XlsPivotTablesCollection .)
Public method Clone(Object)
Creates copy of the collection.
(Inherited from CollectionExtended T .)
Public method Clone(XlsWorksheet, Dictionary String, String )
Clones the PivotTablesCollection to a specified worksheet with a mapping of old to new worksheet names.
(Inherited from XlsPivotTablesCollection .)
Public method Contains
Determines whether the collection contains a specific item.
(Inherited from CollectionBase T .)
Public method CopyTo
Copies the elements of the collection to an array, starting at a particular array index.
(Inherited from CollectionBase T .)
Public method EnsureCapacity
Enlarges internal storage if necessary.
(Inherited from CollectionExtended T .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Protected method FindParent(Type)
Method used to find parent within a specific type.
(Inherited from CollectionExtended T .)
Protected method FindParent(Type, Boolean)
Method used to find parent within a specific type.
(Inherited from CollectionExtended T .)
Public method GetEnumerator
Returns an enumerator that iterates through this instance.
(Inherited from CollectionBase T .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Public method IndexOf
Returns the zero-based index of the first occurrence of a specified item within the collection.
(Inherited from CollectionBase T .)
Public method Insert
Inserts an element into the list at the specified index.
(Inherited from CollectionBase T .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Protected method OnClear
OnClear is invoked before Clear behavior.
(Inherited from CollectionExtended T .)
Protected method OnClearComplete
OnClear is invoked after Clear behavior.
(Inherited from CollectionExtended T .)
Protected method OnInsert
Performs additional processes before inserting a new element into the collection.
(Inherited from CollectionExtended T .)
Protected method OnInsertComplete
Performs additional processes after inserting a new element into the collection.
(Inherited from CollectionExtended T .)
Protected method OnRemove
Performs additional processes before removing an element from the collection.
(Inherited from CollectionExtended T .)
Protected method OnRemoveComplete
Performs additional processes after removing an element from the collection.
(Inherited from CollectionExtended T .)
Protected method OnSet
Performs additional processes before setting a value in the collection.
(Inherited from CollectionExtended T .)
Protected method OnSetComplete
Performs additional processes after setting a value in the collection.
(Inherited from CollectionExtended T .)
Public method Remove(String)
Removes pivot table from the collection.
(Inherited from XlsPivotTablesCollection .)
Public method Remove(IPivotTable)
Removes the specified pivot table from the collection and performs necessary cleanup.
(Inherited from XlsPivotTablesCollection .)
Public method RemoveAt
Removes piovt table from the collection base on the index.
(Inherited from XlsPivotTablesCollection .)
Protected method SetParent
Sets parent object for class.
(Inherited from CollectionExtended T .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Events
See Also