Interface IXLPivotTables

Namespace

SlapKit.Excel.Excel

Assembly

SlapKit.Excel.dll

public interface IXLPivotTables : IEnumerable<IXLPivotTable>, IEnumerable

Inherited Members

IEnumerable<IXLPivotTable>.GetEnumerator()

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

Methods

Add(string, IXLCell, IXLPivotCache)

Add a pivot table that will use the pivot cache.

IXLPivotTable Add(string name, IXLCell targetCell, IXLPivotCache pivotCache)

Parameters

name string

Name of new pivot table.

targetCell IXLCell

A cell where will the pivot table be have it's left top corner.

pivotCache IXLPivotCache

Pivot cache to use for the pivot table.

Returns

IXLPivotTable

Added pivot table.

Exceptions

ArgumentException

There already is a pivot table with the same name.

Add(string, IXLCell, IXLRange)

IXLPivotTable Add(string name, IXLCell targetCell, IXLRange range)

Parameters

name string

targetCell IXLCell

range IXLRange

Returns

IXLPivotTable

Add(string, IXLCell, IXLTable)

IXLPivotTable Add(string name, IXLCell targetCell, IXLTable table)

Parameters

name string

targetCell IXLCell

table IXLTable

Returns

IXLPivotTable

Contains(string)

bool Contains(string name)

Parameters

name string

Returns

bool

Delete(string)

void Delete(string name)

Parameters

name string

DeleteAll()

void DeleteAll()

PivotTable(string)

Get pivot table with the specified name (case insensitive).

IXLPivotTable PivotTable(string name)

Parameters

name string

Name of a pivot table to return.

Returns

IXLPivotTable

Exceptions

KeyNotFoundException

No such pivot table found.