Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Create a Slicer for an Excel Table
Contents
[
Hide
]
Possible Usage Scenarios
A slicer is used to filter data quickly. It can be used to filter data in either a table or a pivot table. Microsoft Excel allows you to create a slicer by selecting a table or pivot table and then clicking Insert > Slicer. Aspose.Cells also allows you to create a 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.
Sample Code