asposecells.api

Class SheetRender

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.

Constructor Summary
SheetRender(worksheet, options)
the construct of SheetRender, need worksheet and ImageOrPrintOptions as params
 
Property Getters/Setters Summary
methodgetPageCount()
Gets the total page count of current worksheet.
methodgetPageScale()
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.
 
Method Summary
methodgetPageSizeInch(pageIndex)
Get page size in inch of output image.
methodtoImage(pageIndex, fileName)
Render certain page to a file.
methodtoImageBytes(pageIndex)
Render certain page to a byte array.
methodtoPrinter(printerName)
Render worksheet to Printer
methodtoPrinter(printerName, jobName)
Render worksheet to Printer
 

    • Constructor Detail

      • SheetRender

        SheetRender(worksheet, options)
        the construct of SheetRender, need worksheet and ImageOrPrintOptions as params
        Parameters:
        worksheet: Worksheet - Indicate which spreadsheet to be rendered.
        options: ImageOrPrintOptions - ImageOrPrintOptions contains some property of output image
    • Property Getters/Setters Detail

      • getPageCount : int 

        int getPageCount()
        
        Gets the total page count of current worksheet.
    • Method Detail

      • getPageSizeInch

        float[] getPageSizeInch(pageIndex)
        Get page size in inch of output image.
        Parameters:
        pageIndex: int - The page index is based on zero.
        Returns:
        Page size of image, [0] for width and [1] for height
      • toImage

         toImage(pageIndex, fileName)
        Render certain page to a file.
        Parameters:
        pageIndex: int - indicate which page is to be converted
        fileName: String - filename of the output image
      • toPrinter

         toPrinter(printerName)
        Render worksheet to Printer
        Parameters:
        printerName: String - the name of the printer , for example: "Microsoft Office Document Image Writer"
      • toPrinter

         toPrinter(printerName, jobName)
        Render worksheet to Printer
        Parameters:
        printerName: String - the name of the printer , for example: "Microsoft Office Document Image Writer"
        jobName: String - set the print job name
      • toImageBytes

         toImageBytes(pageIndex)
        Render certain page to a byte array.
        Parameters:
        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()