获取数据透视表刷新日期和刷新者信息

Aspose.Cells现在支持从工作簿中获取刷新日期和刷新者信息。

PivotTable.RefreshDate返回上次刷新数据透视表报告的日期。类似地，PivotTable.RefreshByWho属性返回上次刷新报告的用户姓名。以下示例演示此功能，示例文件可从以下链接下载。

SourcePivotTable.xlsx

示例代码

// 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);