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 Python via .NET also allows you to create timeline using the Worksheet.timelines.add() method.

How to Create Timeline to a Pivot Table Using Aspose.Cells for Python Excel Library

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 for Python via .NET in the output Excel file.

Sample Code

from aspose.cells import Workbook

#  Load sample Excel file containing pivot table.
wb = Workbook("input.xlsx")
#  Access second worksheet.
sheet = wb.worksheets[1]
#  Access first pivot table inside the worksheet.
pivot = sheet.pivot_tables[0]
#  Add timeline relating to pivot table
index = sheet.timelines.add(pivot, 15, 1, "Ship Date")
#  Access the newly added timeline from timeline collection.
timeline = sheet.timelines[index]
wb.save("output.xlsx")