PivotTableCollection Members
In This Article
#Properties
Name | Description |
---|---|
Count | Gets the number of elements contained in the ICollection. Inherited from ICollection. |
First |
Returns the first pivot table in the Pivot |
Is |
Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection. |
Item[String] | Provides access to an individual pivot table in the collection by its name. |
Last |
Returns the last pivot table in the Pivot |
Sync |
Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection. |
#Methods
Name | Description |
---|---|
Add |
Creates a pivot table with a custom name based on data in the specified cell range and returns the newly created Pivot |
Add |
Creates a pivot table with the default name based on data in the specified cell range and returns the newly created Pivot |
Add |
Creates a new pivot table with a custom name using the specified data cache and returns the newly created Pivot |
Add |
Creates a new pivot table with the default name using the specified data cache and returns the newly created Pivot |
Clear() | Removes all pivot tables from the collection. |
Contains |
Indicates whether the collection contains the specified pivot table. |
Copy |
Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection. |
Get |
Returns an enumerator that iterates through the collection.
Inherited from IEnumerable |
Index |
Returns the index of the specified pivot table in the collection. |
Remove |
Removes the specified pivot table from the collection. |
Remove |
Removes the pivot table at the specified index from the collection. |
See Also