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

import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook, SaveFormat, SlicerStyleType

# Load Source Excel file
workbook = Workbook("sampleFormattingSlicer.xlsx")

# Access first worksheet
worksheet = workbook.getWorksheets().get(0)

# Access the newly added slicer from slicer collection
slicer = worksheet.getSlicers().get(0)

# Set the number of columns of the slicer
slicer.setNumberOfColumns(2)

# Set the type of slicer style
slicer.setStyleType(SlicerStyleType.SLICER_STYLE_LIGHT_6)

# Save the workbook in output XLSX format
workbook.save("outputFormattingSlicer.xlsx", SaveFormat.XLSX)

jpype.shutdownJVM()