officefileapi-devexpress-dot-spreadsheet-dot-table-c4426044.md
Returns the cell range that contains table data.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
CellRange DataRange { get; }
ReadOnly Property DataRange As CellRange
| Type | Description |
|---|---|
| CellRange |
A CellRange object.
|
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.
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.
winforms-spreadsheet-use-custom-cell-editors/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++) {
winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L134
' 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
See Also