Table.DataRange Property

Returns the cell range that contains table data.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

CellRange DataRange { get; }

VB.NET

ReadOnly Property DataRange As CellRange

Property Value

Type	Description
CellRange	A CellRange 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 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#

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.
CellRange range = storesTable.DataRange;
for (int rowOffset = 0; rowOffset < range.RowCount; rowOffset++) {

how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395/CS/WpfSpreadsheet_DataBinding/MainWindow.xaml.cs#L32

// Bind the grid control to the table data.
grid.ItemsSource = expensesTable.DataRange.GetDataSource(options);
#endregion #BindGridToSpreadsheetTable

how-to-bind-a-grid-control-to-the-worksheet-data-t461090/CS/Spreadsheet_BindToDataSource/Form1.cs#L27

// Bind the grid control to the table data.
gridControl1.DataSource = expensesTable.DataRange.GetDataSource(options);
#endregion #BindGridToSpreadsheetTable

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 CellRange = storesTable.DataRange
For rowOffset As Integer = 0 To range.RowCount - 1

how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395/VB/WpfSpreadsheet_DataBinding/MainWindow.xaml.vb#L30

            ' Bind the grid control to the table data.
            grid.ItemsSource = expensesTable.DataRange.GetDataSource(options)
'            #End Region ' #BindGridToSpreadsheetTable

how-to-bind-a-grid-control-to-the-worksheet-data-t461090/VB/Spreadsheet_BindToDataSource/Form1.vb#L25

            ' Bind the grid control to the table data.
            gridControl1.DataSource = expensesTable.DataRange.GetDataSource(options)
'            #End Region ' #BindGridToSpreadsheetTable