Get Pivot Table refresh date and refresh by who information

Aspose.Cells now supports fetching the refresh date and refresh by who information from a workbook.

PivotTable.RefreshDate returns the date on which the PivotTable report was last refreshed. Similarly PivotTable.RefreshByWho property returns the name of the user who refreshed the report last time. Following example demonstrates this feature and sample file can be downloaded from the following link.

SourcePivotTable.xlsx

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Create workbook object from source excel file
Workbook workbook = new Workbook(sourceDir + "sourcePivotTable.xlsx");

// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Access first pivot table inside the worksheet
PivotTable pivotTable = worksheet.PivotTables[0];

// Access pivot table refresh by who
Console.WriteLine("Pivot table refresh by who = " + pivotTable.RefreshedByWho);

// Access pivot table refresh date
Console.WriteLine("Pivot table refresh date = " + pivotTable.RefreshDate);