IXlSheet.DataRange Property

Gets the cell range that encompasses all cells containing data.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

XlCellRange DataRange { get; }

VB.NET

ReadOnly Property DataRange As XlCellRange

Property Value

Type	Description
XlCellRange	An XlCellRange object containing all nonempty cells in a worksheet.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataRange 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;
}

winforms-grid-copy-cells-in-biff8-format-using-excel-export-api/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L148

    this.sheetName = sheet.Name;
    this.dataRange = 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.

winforms-grid-copy-cells-in-biff8-format-using-excel-export-api/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L139

    sheetName = sheet.Name
    dataRange = sheet.DataRange
End Using