Class GridPivotTableCollection

GridPivotTableCollection class

Encapsulates a collection of PivotTable objects.

public class GridPivotTableCollection

Properties

NameDescription
Count { get; }
Item { get; }Gets the GridPivotTable element at the specified index.

Methods

NameDescription
Add(string, string, string)Adds a new PivotTable cache to a PivotCaches collection.
Add(string, GridCellArea, string, string)Adds a new PivotTable cache to a PivotCaches collection.
Add(Worksheet, GridCellArea, string, string)Adds a new PivotTable cache to a PivotCaches collection.
Add(string, GridCellArea, int, int, string)Adds a new PivotTable cache to a PivotCaches collection.
Clear()Clears all PivotTables.
RemoveAt(int)Remove the PivotTable at the specified index.
RemoveAt(int, bool)Deletes the PivotTable at the specified index

See Also