IXlSheet.PrintArea Property

Gets or sets the cell range to be printed.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

XlCellRange PrintArea { get; set; }

VB.NET

Property PrintArea As XlCellRange

Property Value

Type	Description
XlCellRange	An XlCellRange object that specifies an area on the worksheet to be printed.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

PageViewAndLayoutActions.cs

// Set the print area to cells A1:E5.
sheet.PrintArea = XlCellRange.FromLTRB(0, 0, 4, 4);

PageViewAndLayoutActions.vb

' Set the print area to cells A1:E5.
sheet.PrintArea = XlCellRange.FromLTRB(0, 0, 4, 4)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PrintArea property.

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#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L158

    // Specify the data range to be printed.
    sheet.PrintArea = sheet.DataRange;
}

excel-export-library-generate-an-invoice/CS/XLExportExample/Form1.cs#L198

    // Specify the data range to be printed.
    sheet.PrintArea = sheet.DataRange;
}

VB.NET

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L130

' Specify the data range to be printed.
sheet.PrintArea = sheet.DataRange
' Create data validation criteria for the documents exported to the XLSX and XLS formats.

excel-export-library-generate-an-invoice/VB/XLExportExample/Form1.vb#L206

    ' Specify the data range to be printed.
    sheet.PrintArea = sheet.DataRange
End Using

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L148

' Specify the data range to be printed.
sheet.PrintArea = sheet.DataRange
' Create conditional formatting rules to be applied to worksheet data.