渲染切片器
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() |