格式化切片器
Contents
[
Hide
]
格式化切片器
使用Microsoft Excel,您可以通过设置分层切片器的列数、样式等格式化分层切片器。Aspose.Cells for Python via Java提供Slicer.NumberOfColumns和Slicer.StyleType属性来实现此功能。
以下代码段加载包含分层切片器的样本Excel文件,然后访问分层切片器,设置其列数和样式类型,并将其保存为输出Excel文件。屏幕截图显示了执行样本代码后分层切片器的外观。
示例代码
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |