Wiki Markup |
---|
{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} | |
Page History
Overview
Content Tools