Class ExcelSlicerPivotTableCollection¶

Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll

A collection of pivot tables attached to a slicer

public class ExcelSlicerPivotTableCollection : IEnumerable<ExcelPivotTable>, IEnumerable

Inheritance¶

object ← ExcelSlicerPivotTableCollection

Implements¶

IEnumerable
IEnumerable<ExcelPivotTable>

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

Count¶

Number of items in the collection

public int Count { get; }

Property Value¶

int

this[int]¶

The indexer for the collection

public ExcelPivotTable this[int index] { get; }

Property Value¶

ExcelPivotTable

Methods¶

Add(ExcelPivotTable)¶

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

public void Add(ExcelPivotTable pivotTable)

Parameters¶

pivotTable ExcelPivotTable

The pivot table to add

GetEnumerator()¶

Get an Enumerator for the collection.

public IEnumerator<ExcelPivotTable> GetEnumerator()

Returns¶

IEnumerator<ExcelPivotTable>

The Enumerator