格式化切片器

格式化切片器

使用Microsoft Excel,您可以通过设置分层切片器的列数、样式等格式化分层切片器。Aspose.Cells for Python via Java提供Slicer.NumberOfColumns和Slicer.StyleType属性来实现此功能。

以下代码段加载包含分层切片器的样本Excel文件,然后访问分层切片器,设置其列数和样式类型,并将其保存为输出Excel文件。屏幕截图显示了执行样本代码后分层切片器的外观。

todo:image_alt_text

示例代码

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()