Insert Timeline

Possible Usage Scenarios

Instead of adjusting filters to show dates, you can use a PivotTable Timeline——a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control. Microsoft Excel allows you to create timeline by selecting a pivot table and then clicking the Insert > Timeline. Aspose.Cells for java also allows you to create timeline using the [Worksheet.getTimelines.add()] method.

Create Timeline to a Pivot Table

Please see the following sample code. It loads the sample Excel file that contains the pivot table. It then creates the timeline based on the first base pivot field. Finally, it saves the workbook in output XLSX format. The following screenshot shows the timeline created by Aspose.Cells in the output Excel file.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java

// Load sample Excel file containing pivot table.
Workbook wb = new Workbook("input.xlsx");
// Access second worksheet.
Worksheet sheet = wb.getWorksheets().get(1);

//Access PivotTable collection inside the worksheet
PivotTableCollection pivots =	sheet.getPivotTables();
// Access first pivot table
PivotTable pivot = pivots.get(0);

//Access Timeline collection inside the worksheet
TimelineCollection timelines =	sheet.getTimelines();

// Add timeline relating to pivot table
int index = timelines.add(pivot, 15, 1, "Ship Date");

// Access the newly added timeline from timeline collection.
Timeline timeline = timelines.get(index);

wb.save("output.xlsx");