GrapeCity.Documents.Excel.IPivotTables

Interface IPivotTables

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents a collection of all the PivotTable objects on the specified worksheet.

public interface IPivotTables : IEnumerable<IPivotTable>, IEnumerable

Inherited Members

System.Collections.Generic.IEnumerable<GrapeCity.Documents.Excel.IPivotTable>.GetEnumerator()

Properties

Count

Returns the number of objects in the collection (ead-only).

int Count { get; }

Property Value

int

this[int]

Returns a single object from a collection.

IPivotTable this[int index] { get; }

Parameters

index int

The index number for the object.

Property Value

IPivotTable

this[string]

Returns a single object from a collection.

IPivotTable this[string name] { get; }

Parameters

name string

The name for the object.

Property Value

IPivotTable

Methods

Add(IPivotCache, IRange, string)

Adds a new PivotTable report.

IPivotTable Add(IPivotCache PivotCache, IRange TableDestination, string TableName = null)

Parameters

PivotCache IPivotCache

The PivotTable cache on which the new PivotTable report is based. The cache provides data for the report.

TableDestination IRange

The cell in the upper-left corner of the PivotTable report's destination range (the range on the worksheet where the resulting report will be placed). You must specify a destination range on the worksheet that contains the PivotTables object specified by expression.

TableName string

The name of the new PivotTable report.

Returns

IPivotTable

PivotTable object.