Add Pivot Connection

Possible Usage Scenarios

If you want to associate slicer and pivot table in Excel, you need to right-click slicer and select “Report Connections…” item. In the option list, you can operate on the check box. Similarly, if you want to associate slicer and pivot table using Aspose.Cells for Python via .NET API programmatically, please use the Slicer.add_pivot_connection(pivot) method. It will associate slicer and pivot table.

How to Associate Slicer and PivotTable Using Aspose.Cells for Python Excel Library

The following sample code loads the sample Excel file that contains an existing slicer. It accesses the Slicer and then associates Slicer and PivotTable. Finally, it saves the workbook as output Excel file.

Sample Code