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

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

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

SourcePivotTable.xlsx

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Instantiating a Workbook object
Workbook workbook = new Workbook(srcDir + "sourcePivotTable.xlsx");

// Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

// Access first pivot table inside the worksheet
PivotTable pivotTable = worksheet.getPivotTables().get(0);

// Access pivot table refresh by who property
System.out.println("Pivot table refresh by who = " + pivotTable.getRefreshedByWho());

// Access pivot table refresh date
System.out.println("Pivot table refresh date = " + pivotTable.getRefreshDate());