Formatting Slicer

Possible Usage Scenarios

You can format the slicer in Microsoft Excel by setting its number of columns or by setting its style etc. Aspose.Cells also allows you to do this using the Slicer.NumberOfColumns and Slicer.StyleType properties.

Formatting Slicer

Please see the following code, it loads the sample Excel file that contains a slicer. It accesses the slicer and sets its number of columns and style type and saves it as output Excel file. The screenshot shows how the slicer looks after the execution of the sample code.

todo:image_alt_text

Sample Code

Create Slicer to Excel Table Add Pivot Connection