GrapeCity.Documents.Excel.IPivotTables.Count

Count Property

Count

Gets the number of IPivotTable objects in this collection.

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

Declaration

int Count { get; }

ReadOnly Property Count As Integer

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");
int count = worksheet.PivotTables.Count;