Table.DataRange Property

Gets the cell range that contains table data.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

Range DataRange { get; }

VB.NET

ReadOnly Property DataRange As Range

Property Value

Type	Description
Range	A Range object.

Remarks

The table data range is highlighted in the following image.

To get a cell range that contains the whole table, use the Table.Range property. The Table.HeaderRowRange and Table.TotalRowRange properties return cell ranges containing a table’s header row and total row respectively.

To obtain the cell range of an individual table column, use the TableColumn.Range or TableColumn.DataRange property.

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-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L146

// Select the default store and assign it to the cell G12 on the "Invoice" worksheet.
Range range = storesTable.DataRange;
for (int rowOffset = 0; rowOffset < range.RowCount; rowOffset++) {

VB.NET

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L150

' Select the default store and assign it to the cell G12 on the "Invoice" worksheet.
Dim range As Range = storesTable.DataRange
For rowOffset As Integer = 0 To range.RowCount - 1