GrapeCity.Documents.Excel.IPivotCaches

Interface IPivotCaches

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the collection of memory caches from the PivotTable reports in a workbook.

public interface IPivotCaches : IEnumerable<IPivotCache>, IEnumerable

Inherited Members

IEnumerable<IPivotCache>.GetEnumerator()

Properties

Count

Returns the number of objects in the collection.

int Count { get; }

Property Value

int

this[int]

Gets a PivotCache by index.

IPivotCache this[int index] { get; }

Parameters

index int

Property Value

IPivotCache

Methods

Create(object)

Creates a new PivotCache using range or table.

IPivotCache Create(object SourceData)

Parameters

SourceData object

The range or table data for the new PivotTable cache.

Returns

IPivotCache

PivotCache.

Exceptions

ArgumentException

If SourceData is not a range or table.