SheetRender
SheetRender class
Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG, TIFF..) The constructor of this class , must be used after modification of pagesetup, cell style.
Constructors
| Name | Description |
|---|---|
| SheetRender | the construct of SheetRender, need worksheet and ImageOrPrintOptions as params |
Properties
| Name | Type | Description |
|---|---|---|
| PageCount | int | Gets the total page count of current worksheet. |
| PageScale | float | Gets calculated page scale of the sheet. Returns the set scale if PageSetup.Zoom is set. Otherwise, returns the calculat |
Methods
| Name | Description |
|---|---|
| getPageSizeInch | Get page size in inch of output image. |
| toImage | Render certain page to a file. |
| toPrinter | Render worksheet to Printer |
| toImageBytes | Render certain page to a byte array. |
SheetRender(worksheet, options)
the construct of SheetRender, need worksheet and ImageOrPrintOptions as params
| Parameter | Type | Description |
|---|---|---|
| worksheet | Worksheet | Indicate which spreadsheet to be rendered. |
| options | ImageOrPrintOptions | ImageOrPrintOptions contains some property of output image |
SheetRender.PageCount property
Gets the total page count of current worksheet.
Type: int
SheetRender.PageScale property
Gets calculated page scale of the sheet. Returns the set scale if PageSetup.Zoom is set. Otherwise, returns the calculated scale according to PageSetup.FitToPagesWide and PageSetup.FitToPagesTall .
Type: float
getPageSizeInch(pageIndex)
Get page size in inch of output image.
| Parameter | Type | Description |
|---|---|---|
| pageIndex | int | The page index is based on zero. |
Returns: Page size of image, [0] for width and [1] for height
toImage(pageIndex, fileName)
Render certain page to a file.
| Parameter | Type | Description |
|---|---|---|
| pageIndex | int | indicate which page is to be converted |
| fileName | String | filename of the output image |
toPrinter(printerName) (1 of 2)
Render worksheet to Printer
| Parameter | Type | Description |
|---|---|---|
| printerName | String | the name of the printer , for example: “Microsoft Office Document Image Writer” |
toPrinter(printerName, jobName) (2 of 2)
Render worksheet to Printer
| Parameter | Type | Description |
|---|---|---|
| printerName | String | the name of the printer , for example: “Microsoft Office Document Image Writer” |
| jobName | String | set the print job name |
toImageBytes(pageIndex)
Render certain page to a byte array.
| Parameter | Type | Description |
|---|---|---|
| pageIndex | int | Indicate which page is to be converted |
Returns: A byte array.
Example:
import jpype
import asposecells
jpype.startJVM()
from asposecells.api import *
wb = Workbook("Book2.xlsx")
imgOptions = ImageOrPrintOptions()
imgOptions.setHorizontalResolution(200)
imgOptions.setVerticalResolution(300)
imgOptions.setImageFormat(ImageFormat.getJpeg())
worksheet = wb.getWorksheets().get(0)
sheetRender = SheetRender(worksheet, imgOptions)
with open("sheet1.jpeg", "wb") as w:
content = sheetRender.toImageBytes(0)
w.write(content)
jpype.shutdownJVM()