Class ExcelSlicerPivotTableCollection

A collection of pivot tables attached to a slicer

Inheritance

System.Object

ExcelSlicerPivotTableCollection

Implements

System.Collections.Generic.IEnumerable<ExcelPivotTable>

System.Collections.IEnumerable

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Drawing.Slicer

Assembly: EPPlus.dll

Syntax

public class ExcelSlicerPivotTableCollection : IEnumerable<ExcelPivotTable>, IEnumerable

Properties

Count

Number of items in the collection

Declaration

public int Count { get; }

Property Value

Type	Description
System.Int32

Item[Int32]

The indexer for the collection

Declaration

public ExcelPivotTable this[int index] { get; }

Parameters

Type	Name	Description
System.Int32	index	The index

Property Value

Type	Description
ExcelPivotTable	The pivot table at the specified index

Methods

Add(ExcelPivotTable)

Adds a new pivot table to the collection. All pivot table in this collection must share the same cache.

Declaration

public void Add(ExcelPivotTable pivotTable)

Parameters

Type	Name	Description
ExcelPivotTable	pivotTable	The pivot table to add

GetEnumerator()

Declaration

public IEnumerator<ExcelPivotTable> GetEnumerator()

Returns

Type	Description
System.Collections.Generic.IEnumerator<ExcelPivotTable>

Explicit Interface Implementations

IEnumerable.GetEnumerator()

Declaration

IEnumerator IEnumerable.GetEnumerator()

Returns

Type	Description
System.Collections.IEnumerator

Implements

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable