All docs
V21.2
21.2
21.1
20.2
The page you are viewing does not exist in version 20.2. This link will take you to the root page.
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

How to: Save a Cell Range as an Image

  • 2 minutes to read

Call the CellRangeExtensions.ExportToImage extension method for a CellRange object to save a cell range as an image. Pass an ImageFileFormat enumeration member to this method to specify the output image format.

Important

The CellRangeExtensions class is defined in the DevExpress.Docs.v21.2.dll assembly. Add this assembly to your project to use cell range extensions. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this assembly in production code.

The following code snippet demonstrates how to export a cell range as an image:

Spreadsheet - Export a Cell Range to an Image

using DevExpress.Spreadsheet;
// ...

using (Workbook workbook = new Workbook())
{
    workbook.LoadDocument("InvestmentPortfolio.xlsx", DocumentFormat.Xlsx);
    Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
    worksheet.Range["B1:I25"].ExportToImage("RangeImage.png", ImageFileFormat.Png);
}

Customize Export Settings

Create a RangeImageOptions class instance and pass it to the CellRange.ExportToImage method to specify export options. The following options are available:

RangeImageOptions Property Description
Resolution Defines the image resolution (in DPI).
Scale Specifies how to scale worksheet content before it is exported to an image.
BackgroundColor Allows you to fill the image background with a color.
ExportHeadings Specifies whether to include row and column headings in the output image.
ExportDrawingObjects Specifies whether to include drawing objects (charts, shapes, and pictures) in the output image.
ExportGridlines Specifies whether to include cell gridlines in the output image.
GridlineColor Defines the gridline color.
BlackAndWhite Allows you to save a cell range as a black and white image.

The following example demonstrates how to save a cell range as an image and define export options to create the following image:

Spreadsheet - Export a Cell Range to an Image and Set Export Options

using DevExpress.Spreadsheet;
using System.Drawing;
// ...

using (Workbook workbook = new Workbook())
{
    workbook.LoadDocument("InvestmentPortfolio.xlsx", DocumentFormat.Xlsx);
    Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
    var exportOptions = new RangeImageOptions
    {
        Resolution = 192,
        ExportHeadings = true,
        ExportGridlines = true,
        GridlineColor = Color.Gray,
        BackgroundColor = Color.FromArgb(0xF2, 0xF2, 0xF2)
    };
    worksheet.Range["B1:I25"].ExportToImage("RangeImage.png", ImageFileFormat.Png, exportOptions);
}