How to: Bind a Data Grid to a Cell Range

• Apr 15, 2018
• 2 minutes to read

This example demonstrates how to bind the GridControl to a table in a worksheet. For this, use the Range.GetDataSource method to create a data source object from the cell range with table data (Table.DataRange) and then assign it to the grid’s DataControlBase.ItemsSource property.

The two-way binding is supported: any changes to table data (such as editing values, inserting and deleting rows, sorting and filtering) are immediately propagated to the Data Grid, and data edited in the grid is reflected in the table.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395.

MainWindow.xaml.vb

Dim workbook As IWorkbook = spreadsheet.Document
Dim worksheet As Worksheet = workbook.Worksheets(0)
' Access the table on the worksheet. 
Dim expensesTable As Table = worksheet.Tables(0)
' Specify the data source settings.
Dim options As New RangeDataSourceOptions()
options.PreserveFormulas = True
options.SkipHiddenRows = True
' Bind the grid control to the table data.
grid.ItemsSource = expensesTable.DataRange.GetDataSource(options)

MainWindow.xaml.cs

IWorkbook workbook = spreadsheet.Document;
Worksheet worksheet = workbook.Worksheets[0];
// Access the table on the worksheet. 
Table expensesTable = worksheet.Tables[0];
// Specify the data source settings.
RangeDataSourceOptions options = new RangeDataSourceOptions();
options.PreserveFormulas = true;
options.SkipHiddenRows = true;
// Bind the grid control to the table data.
grid.ItemsSource = expensesTable.DataRange.GetDataSource(options);

The following image shows the resulting application.