devexpress-examples/how-to-bind-a-grid-control-to-the-worksheet-data-wpf-spreadsheet-t461395

Use the SpreadsheetControl data as a data source for the Grid Control

Spreadsheet for WPF - Bind a GridControl to the Worksheet Data

This example demonstrates how to bind the Grid Control to the Spreadsheet data.

Use the Range.GetDataSource method to create a data source object from a specific cell range in a worksheet, and then assign it to the GridControl.ItemsSource property. The two-way binding is supported: any changes to worksheet (such as editing values, inserting and deleting rows, sorting and filtering) are immediately propagated to the Data Grid, and editing data in the grid is reflected in the spreadsheet.

Files to Review

• MainWindow.xaml (VB: MainWindow.xaml)
• MainWindow.xaml.cs (VB: MainWindow.xaml.vb)

Documentation

• Data Binding in Spreadsheet for WPF