GrapeCity.Documents.Excel.IWorksheet.PivotTables

PivotTables Property

PivotTables

Gets the collection of PivotTable reports on the worksheet.

Use this property to access existing PivotTable reports on the worksheet or to add new ones through the returned IPivotTables collection.

Declaration

IPivotTables PivotTables { get; }

ReadOnly Property PivotTables As IPivotTables

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Category", "Amount"},
    {"Beverages", 100},
    {"Snacks", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotTables pivotTables = worksheet.PivotTables;