Rendering Slicer

Rendering Slicer

Aspose.Cells for Python via Java supports the rendering of slicer shape. The following code snippet loads the sample Excel file that contains a slicer. It converts the worksheet into an image by setting the print area that covers only the slicer. The flowing image is the output image that shows the rendered slicer. As you can see, the slicer has been rendered properly it looks the same as in the sample Excel file.

Sample Code

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