渲染切片器
Contents
[
Hide
]
渲染切片器
Aspose.Cells for Python via Java 支持切片形状的渲染。以下代码片段加载示例 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, ImageOrPrintOptions, ImageType, SheetRender | |
| # Load Source Excel file | |
| workbook = Workbook("sampleRenderingSlicer.xlsx") | |
| # Access first worksheet | |
| worksheet = workbook.getWorksheets().get(0) | |
| # Set the print area because we want to render slicer only | |
| worksheet.getPageSetup().setPrintArea("B15:E25") | |
| # Specify image or print options, set one page per sheet and only area to true | |
| imgOpts = ImageOrPrintOptions() | |
| imgOpts.setHorizontalResolution(200) | |
| imgOpts.setVerticalResolution(200) | |
| imgOpts.setImageType(ImageType.PNG) | |
| imgOpts.setOnePagePerSheet(True) | |
| imgOpts.setOnlyArea(True) | |
| # Create sheet render object and render worksheet to image | |
| sheetrender = SheetRender(worksheet, imgOpts) | |
| sheetrender.toImage(0, "outputRenderingSlicer.png") | |
| jpype.shutdownJVM() |