PivotTables

Description

The PivotTables collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use PivotTables.

C#

vb.net

Name	Description
Count	Returns the number of PivotTables in the worksheet.

Name	Description
Item(Int32)	Returns the `PivotTable` at the specified 0-based position in the `PivotTables` collection.
Item(String)	Returns the `PivotTable` with the specified name in the `PivotTables` collection.

Name	Description
CreatePivotTable(Area, Int32, Int32)	Creates a new, blank PivotTable for the specified area. A PivotTable created by this method is part of `PivotTables` collection.
CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)	Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of `PivotTables` collection.
GetEnumerator()	Returns an IEnumerator for the PivotTables in a Worksheet .