更新切片器
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() |