更改切片器属性
Contents
[
Hide
]
可能的使用场景
可能会出现您想要更改切片器属性，例如位置或行高的情况。Aspose.Cells for Python via .NET为您提供了更新这些属性的选项。
如何使用Aspose.Cells for Python Excel库更改切片器属性
请查看以下示例代码。它加载包含表的sample Excel file，然后基于第一列创建切片器，并更改其属性，如行高、宽度、是否可打印、标题等。将工作簿另存为outputChangeSlicerProperties.xlsx。
示例代码
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
| from aspose.cells import SaveFormat, Workbook | |
| from aspose.cells.drawing import PlacementType | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Load sample Excel file containing a table. | |
| workbook = Workbook(sourceDir + "sampleCreateSlicerToExcelTable.xlsx") | |
| # Access first worksheet. | |
| worksheet = workbook.worksheets[0] | |
| # Access first table inside the worksheet. | |
| table = worksheet.list_objects[0] | |
| # Add slicer | |
| idx = worksheet.slicers.add(table, 0, "H5") | |
| slicer = worksheet.slicers[idx] | |
| slicer.placement = PlacementType.FREE_FLOATING | |
| slicer.row_height_pixel = 50 | |
| slicer.width_pixel = 500 | |
| slicer.title = "Aspose" | |
| slicer.alternative_text = "Alternate Text" | |
| slicer.is_printable = False | |
| slicer.is_locked = False | |
| # Refresh the slicer. | |
| slicer.refresh() | |
| # Save the workbook in output XLSX format. | |
| workbook.save(outputDir + "outputChangeSlicerProperties.xlsx", SaveFormat.XLSX) |