Class ExcelPivotTableCollection¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

A collection of pivottable objects

public class ExcelPivotTableCollection : IEnumerable<ExcelPivotTable>, IEnumerable

Inheritance¶

object ← ExcelPivotTableCollection

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 pivottable Index. Base 0.

public ExcelPivotTable this[int Index] { get; }

Property Value¶

ExcelPivotTable

this[string]¶

Pivottabes accesed by name

public ExcelPivotTable this[string Name] { get; }

Property Value¶

ExcelPivotTable

Methods¶

Add(ExcelAddressBase, ExcelRangeBase, string)¶

Create a pivottable on the supplied range

public ExcelPivotTable Add(ExcelAddressBase Range, ExcelRangeBase Source, string Name)

Parameters¶

Range ExcelAddressBase

The range address including header and total row

Source ExcelRangeBase

The Source data range address

Name string

The name of the pivottable. Must be unique

Returns¶

ExcelPivotTable

The pivottable object

Add(ExcelAddressBase, ExcelTable, string)¶

Create a pivottable on the supplied range

public ExcelPivotTable Add(ExcelAddressBase Range, ExcelTable Source, string Name)

Parameters¶

Range ExcelAddressBase

The range address including header and total row

Source ExcelTable

The source table

Name string

The name of the pivottable. Must be unique

Returns¶

ExcelPivotTable

The pivottable object

Add(ExcelAddressBase, ExcelPivotCacheDefinition, string)¶

Create a pivottable on the supplied range

public ExcelPivotTable Add(ExcelAddressBase Range, ExcelPivotCacheDefinition PivotCacheDefinition, string Name)

Parameters¶

Range ExcelAddressBase

The range address including header and total row

PivotCacheDefinition ExcelPivotCacheDefinition

A pivot table cache shared with another pivot table

Name string

The name of the pivottable. Must be unique

Returns¶

ExcelPivotTable

The pivottable object

Delete(string, bool)¶

Delete the pivottable with the supplied name

public void Delete(string Name, bool ClearRange = false)

Parameters¶

Name string

The name of the pivottable

ClearRange bool

Clear the table range

Delete(int, bool)¶

Delete the pivot table at the specified index

public void Delete(int Index, bool ClearRange = false)

Parameters¶

Index int

The index in the PivotTable collection

ClearRange bool

Clear the table range

Delete(ExcelPivotTable, bool)¶

Delete the supplied pivot table

public void Delete(ExcelPivotTable PivotTable, bool ClearRange = false)

Parameters¶

PivotTable ExcelPivotTable

The PivotTable to remove from the collection

ClearRange bool

Clear the table range

GetEnumerator()¶

Gets the enumerator of the collection

public IEnumerator<ExcelPivotTable> GetEnumerator()

Returns¶

IEnumerator<ExcelPivotTable>

The enumerator