Click or drag to resize

PivotCachesCollection Class

Represents a collection of PivotCache objects in an Excel workbook. Each PivotCache object contains the data used by one or more PivotTables.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet.Collections CollectionBase IPivotCache
Spire.Xls.Core.Spreadsheet.Collections CollectionExtended IPivotCache
Spire.Xls.Core.Spreadsheet.Collections XlsPivotCachesCollection
Spire.Xls.Collections PivotCachesCollection

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

The PivotCachesCollection 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. Read-only.
(Inherited from XlsPivotCachesCollection .)
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
Gets or sets the item at the specified index in the collection.trigger OnSet and OnSetComplete method when set item
(Inherited from CollectionBase T .)
Protected property List
Gets the list of elements in the instance.
(Inherited from CollectionBase T .)
Public property Parent
Gets the parent workbook to which this worksheet belongs.
(Inherited from XlsPivotCachesCollection .)
Public property Workbook
Represents an Excel workbook, providing methods and properties to manipulate and access the contents of an Excel file.
(Inherited from XlsPivotCachesCollection .)
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(CellRange)
Creates new chache object inside this collection.
(Inherited from XlsPivotCachesCollection .)
Public method Add(XlsPivotCache)
Adds single item to the collection.
(Inherited from XlsPivotCachesCollection .)
Public method Clear
Clears collection
(Inherited from XlsPivotCachesCollection .)
Public method Clone
Creates a new object that is a copy of the specified parent object.
(Inherited from XlsPivotCachesCollection .)
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
Removes the specified pivot cache from the collection.
(Inherited from XlsPivotCachesCollection .)
Public method RemoveAt
Removes the Pivot cache.
(Inherited from XlsPivotCachesCollection .)
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