GrapeCity.Documents.Excel.IPivotCaches.Item

this Property

this[int]

Gets the IPivotCache at the specified index.

Use this property to retrieve a PivotCache from the workbook's IPivotCaches collection after it has been created with Create(object).

Declaration

IPivotCache this[int index] { get; }

ReadOnly Default Property Item(index As Integer) As IPivotCache

Parameters

Type	Name	Description
int	index	The index of the PivotCache to retrieve.

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Category", "Amount"},
    {"Beverages", 100},
    {"Snacks", 200}
};
IPivotCaches pivotCaches = workbook.PivotCaches;
pivotCaches.Create(worksheet.Range["A1:B3"]);
IPivotCache pivotCache = pivotCaches[0];