GrapeCity.Documents.Excel.IPivotCache.RefreshDate

RefreshDate Property

RefreshDate

Gets the date on which the PivotTable cache was last refreshed.

Declaration

DateTime RefreshDate { get; }

ReadOnly Property RefreshDate As Date

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Score"},
    {"Alice", 100},
    {"Bob", 200}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B3"]);
pivotCache.Refresh();
DateTime refreshDate = pivotCache.RefreshDate;