渲染切片器

渲染切片器

Aspose.Cells for Python via Java支持呈现分层切片器形状。以下代码段加载包含分层切片器的样本Excel文件,并将工作表转换为图片,设置打印区域仅覆盖分层切片器。生成的图片是显示了呈现的分层切片器的输出图片。从图片中,您可以看到分层切片器已正确呈现,外观与样本Excel文件中的相同。

todo:image_alt_text

示例代码

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