移除切片器

移除切片器

要在Microsoft Excel中删除分层切片器,只需选择分层切片器,然后按下删除按钮。要实现Aspose.Cells for Python via Java中的这一操作,请使用Worksheet.getSlicers().remove()方法。它将从工作表中删除分层切片器。 

以下代码段加载包含现有分层切片器的样本Excel文件,然后访问分层切片器,删除它,并保存为输出Excel文件。以下屏幕截图显示了将被删除的分层切片器。

todo:image_alt_text

示例代码

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