Class ExcelPivotTableCollection

A collection of pivottable objects

Inheritance

System.Object

ExcelPivotTableCollection

Implements

System.Collections.Generic.IEnumerable<ExcelPivotTable>

System.Collections.IEnumerable

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

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

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

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Experior.Core.Data.OfficeOpenXml.Table.PivotTable

Assembly: Experior.Core.dll

Syntax

public class ExcelPivotTableCollection : IEnumerable<ExcelPivotTable>, IEnumerable

Properties

Count

Declaration

public int Count { get; }

Property Value

Type	Description
System.Int32

Item[Int32]

The pivottable Index. Base 0.

Declaration

public ExcelPivotTable this[int Index] { get; }

Parameters

Type	Name	Description
System.Int32	Index

Property Value

Type	Description
ExcelPivotTable

Item[String]

Pivottabes accesed by name

Declaration

public ExcelPivotTable this[string Name] { get; }

Parameters

Type	Name	Description
System.String	Name	The name of the pivottable

Property Value

Type	Description
ExcelPivotTable	The Pivotable. Null if the no match is found

Methods

Add(ExcelAddressBase, ExcelRangeBase, String)

Create a pivottable on the supplied range

Declaration

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

Parameters

Type	Name	Description
ExcelAddressBase	Range	The range address including header and total row
ExcelRangeBase	Source	The Source data range address
System.String	Name	The name of the table. Must be unique

Returns

Type	Description
ExcelPivotTable	The pivottable object

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