移除切片器
Contents
[
Hide
]
移除切片器
要在Microsoft Excel中删除分层切片器,只需选择分层切片器,然后按下删除按钮。要实现Aspose.Cells for Python via Java中的这一操作,请使用Worksheet.getSlicers().remove()方法。它将从工作表中删除分层切片器。
以下代码段加载包含现有分层切片器的样本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("sampleRemovingSlicer.xlsx") | |
# Access first worksheet | |
worksheet = workbook.getWorksheets().get(0) | |
# Access the newly added slicer from slicer collection | |
slicer = worksheet.getSlicers().get(0) | |
# Remove slicer | |
worksheet.getSlicers().remove(slicer) | |
# Save the workbook in output XLSX format | |
workbook.save("outputRemovingSlicer.xlsx", SaveFormat.XLSX) | |
jpype.shutdownJVM() |