Converting Worksheet to Different Image Formats

Converting Worksheet to Image

Sometimes, it is useful to save a picture of a worksheet. Images can be shared online, inserted into other documents (reports written in Microsoft Word, for example, or PowerPoint presentations).

Aspose.Cells provides image export through the SheetRender class. This class represents the worksheet that will be rendered to an image. The SheetRender class provides the toImage() method for converting a worksheet to an image file. BMP, PNG, JPEG, TIFF, and EMF formats are supported.

The code below shows how to convert a worksheet in a Microsoft Excel file to a PNG file.

Converting Worksheet to SVG

SVG stands for Scalable Vector Graphics. SVG is a specification based on XML standards for two-dimensional vector graphics. It is an open standard that has been under development by the World Wide Web Consortium (W3C) since 1999.

Since the release of v7.1.0, Aspose.Cells for Java can convert worksheets into SVG images.

To use this feature, you need to import the com.aspose.cells namespace to your program or project. It has several valuable classes for rendering and printing, for example, SheetRender, ImageOrPrintOptions, WorkbookRender, and others.

The com.aspose.cells.ImageOrPrintOptions class specifies that the worksheet will be saved in SVG format.

The SheetRender class takes the object of ImageOrPrintOptions as a parameter that sets the save format to SVG format.

The following code snippet shows how to convert a worksheet in an Excel file to an SVG image file.

Render active worksheet in a workbook

A simple way to convert active worksheet in a workbook is to set the active sheet index and then save the workbook as SVG. It will render the active sheet to SVG. Following sample code demonstrates this feature: