Create Slicer to Excel Table
Contents
[
Hide
]
Possible Usage Scenarios
A 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 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.Slicers.Add() method.
Create Slicer to Excel Table
Please see the following sample code. It loads the sample Excel file that contains a table. It then creates the slicer based on the first column. Finally, it saves the workbook in output XLSX format.