GrapeCity.Documents.Excel.IPivotCaches.Count

Count Property

Count

Gets the number of IPivotCache objects in this collection.

Use this property to determine how many PivotTable caches are currently available in the workbook.

Declaration

int Count { get; }

ReadOnly Property Count As Integer

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Product", "Amount"},
    {"Apple", 100},
    {"Banana", 200}
};
worksheet.Range["D1:E3"].Value = new object[,] {
    {"Region", "Sales"},
    {"East", 300},
    {"West", 250}
};
IPivotCaches pivotCaches = workbook.PivotCaches;
pivotCaches.Create(worksheet.Range["A1:B3"]);
pivotCaches.Create(worksheet.Range["D1:E3"]);
int count = pivotCaches.Count;