GrapeCity.Documents.Excel.IPivotTables

IPivotTables Interface

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

Use this interface to access existing PivotTable reports on a worksheet or to add new ones through Add(IPivotCache, IRange, string). An IPivotTables instance is typically obtained from PivotTables.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPivotTables : IEnumerable<IPivotTable>, IEnumerable

Public Interface IPivotTables
    Inherits IEnumerable(Of IPivotTable), IEnumerable

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "PivotTable1");
IPivotTables pivotTables = worksheet.PivotTables;

Properties

Name	Description
Count	Gets the number of IPivotTable objects in this collection. Use this property to determine how many PivotTable reports are available on the worksheet.
this[int]	Returns a single object from a collection.
this[string]	Returns a single object from a collection.

Name

Description

Count

Gets the number of IPivotTable objects in this collection.

Use this property to determine how many PivotTable reports are available on the worksheet.

this[int]

Returns a single object from a collection.

this[string]

Returns a single object from a collection.

Methods

Name Description

Name	Description
Add(IPivotCache, IRange, string)	Adds a new PivotTable report. Creates a PivotTable report from the specified IPivotCache and places it at the specified destination range on the worksheet that contains this `IPivotTables` collection.

Add(IPivotCache, IRange, string)

Adds a new PivotTable report.

Creates a PivotTable report from the specified IPivotCache and places it at the specified destination range on the worksheet that contains this IPivotTables collection.