IXlSheet.DataRange Property

Gets the cell range that encompasses all cells containing data.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v22.2.Core.dll

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design

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 snippet (auto-collected from DevExpress Examples) contains a reference 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#

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L148

    this.sheetName = sheet.Name;
    this.dataRange = sheet.DataRange;
}

VB.NET

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L151

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