更新切片器
Contents
[
Hide
]
更新分析器
Aspose.Cells for Python via Java支持更新分层切片器。为此,API提供了Slicer.SlicerCache.SlicerCacheItems属性,用于选择或取消选择分层切片器项目。以下代码段加载包含分层切片器的样本Excel文件,取消选择分层切片器的第2和第3项,并使用Slicer.refresh()方法刷新分层切片器。然后将工作簿保存为 输出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 | |
# Load Source Excel file | |
workbook = Workbook("sampleUpdatingSlicer.xlsx") | |
# Access first worksheet | |
worksheet = workbook.getWorksheets().get(0) | |
# Access the first slicer inside the slicer collection | |
slicer = worksheet.getSlicers().get(0) | |
# Access the slicer items | |
scItems = slicer.getSlicerCache().getSlicerCacheItems() | |
# Unselect 2nd and 3rd slicer items | |
scItems.get(1).setSelected(False) | |
scItems.get(2).setSelected(False) | |
# Refresh the slicer | |
slicer.refresh() | |
# Save the workbook in output XLSX format | |
workbook.save("outputUpdatingSlicer.xlsx", SaveFormat.XLSX) | |
jpype.shutdownJVM() |