officefileapi-devexpress-dot-spreadsheet-dot-worksheet-dot-setprintrange-x28-devexpress-dot-spreadsheet-dot-cellrange-x29.md
Defines the print range.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void SetPrintRange(
CellRange range
)
Sub SetPrintRange(
range As CellRange
)
| Name | Type | Description |
|---|---|---|
| range | CellRange |
A CellRange object that is the worksheet range to print.
|
The SetPrintRange method sets the worksheet print range. To extend the print range, use the Worksheet.AddPrintRange method.
// 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();
' 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();
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.
// for the worksheet.
Sheet.SetPrintRange(Sheet.GetDataRange());
Sheet.PrintOptions.FitToPage = true;
See Also