Page History

{introducedin: 8.4}{description}
{excerpt}The {{[EW8:PivotTables]}} collection represents the set of PivotTables in a worksheet. To return a PivotTables collection, use {{[EW8:PivotTables]}}.{excerpt}
{signature:C#}
[DefaultMember("Item")]
 public sealed class PivotTables: System.Collections.Generic.IEnumerable<PivotTables>
{signature}{signature:vb.net}
<DefaultMember("Item")> _
	Public NotInheritable Class PivotTables
		Implements System.Collections.Generic.IEnumerable(Of PivotTable)
{signature}
{properties}
|| Name || Description ||
| [Count|PivotTables.Count] | {excerpt-include:PivotTables.Count|nopanel=true} |
{indexers}
|| Name || Description ||
| [Item(Int32)|PivotTables.Item(Int32)] | {excerpt-include:PivotTables.Item(Int32)|nopanel=true} |
| [Item(String)|PivotTables.Item(String)] | {excerpt-include:PivotTables.Item(String)|nopanel=true} |
{methods}
|| Name || Description ||
| [CreatePivotTable(Area, Int32, Int32)|PivotTables.CreatePivotTable(Area, Int32, Int32)] | {excerpt-include:PivotTables.CreatePivotTable(Area, Int32, Int32)|nopanel=true} |
| [CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)|PivotTables.CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)] | {excerpt-include:PivotTables.CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)|nopanel=true} |
| [GetEnumerator()|PivotTables.GetEnumerator()] | {excerpt-include:PivotTables.GetEnumerator()|nopanel=true} |