Worksheet.SetPrintRange(CellRange) Method

Defines the print range.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void SetPrintRange(
    CellRange range
)

VB.NET

Sub SetPrintRange(
    range As CellRange
)

Parameters

Name	Type	Description
range	CellRange	A CellRange object that is the worksheet range to print.

Remarks

The SetPrintRange method sets the worksheet print range. To extend the print range, use the Worksheet.AddPrintRange method.

Example

C#

// Define a print area on a worksheet.
CellRange printArea = worksheet["B1:F39"];
worksheet.SetPrintRange(printArea);

// Enlarge the print area by adding adjacent cells.
// An additional print area is created if you add non-adjacent cells to the print area.
worksheet.AddPrintRange(worksheet["B40:F50"]);

// Uncomment the following line to clear the print area and print the entire worksheet.
// worksheet.ClearPrintRange();

VB.NET

' Define a print area on a worksheet.
Dim printArea As CellRange = worksheet("B1:F39")
worksheet.SetPrintRange(printArea)

' Enlarge the print area by adding adjacent cells.
' An additional print area is created if you add non-adjacent cells to the print area.
worksheet.AddPrintRange(worksheet("B40:F50"))

' Uncomment the following line to clear the print area and print the entire worksheet.
' worksheet.ClearPrintRange();

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SetPrintRange(CellRange) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-create-loan-amortization-schedule-within-blazor-server-app/CS/BlazorAppSpreadsheet/Code/DocumentGenerator.cs#L200

// for the worksheet.
Sheet.SetPrintRange(Sheet.GetDataRange());
Sheet.PrintOptions.FitToPage = true;