Formatting Slicer

Formatting Slicer

Using Microsoft Excel, you can format the slicer by setting its number of columns, styles, etc. Aspose.Cells for Python via Java provides the Slicer.NumberOfColumns and Slicer.StyleType properties to achieve this.

The following code snippet 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.

Sample Code