Create Slicer to a Pivot Table

Possible Usage Scenarios

The slicer is used to filter data quickly. It can be used to filter data both in a table or pivot table. Microsoft Excel allows you to create a slicer by selecting a table or pivot table and then clicking the Insert > Slicer. Aspose.Cells also allows you to create slicer using the Worksheet.getSlicers().add() method.

Create Slicer 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 slicer based on the first base pivot field. Finally, it saves the workbook in output XLSX and output XLSB format. The following screenshot shows the slicer created by Aspose.Cells in the output Excel file.

todo:image_alt_text

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(srcDir + "sampleCreateSlicerToPivotTable.xlsx");
// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);
// Access first pivot table inside the worksheet.
PivotTable pt = ws.getPivotTables().get(0);
// Add slicer relating to pivot table with first base field at cell B22.
int idx = ws.getSlicers().add(pt, "B22", pt.getBaseFields().get(0));
// Access the newly added slicer from slicer collection.
Slicer slicer = ws.getSlicers().get(idx);
// Save the workbook in output XLSX format.
wb.save(outDir + "outputCreateSlicerToPivotTable.xlsx", SaveFormat.XLSX);
// Save the workbook in output XLSB format.
wb.save(outDir + "outputCreateSlicerToPivotTable.xlsb", SaveFormat.XLSB);