Category / Section
How to import the data from excel to WPF DataGrid (SfDataGrid)?
1 min read
You can read the data from Excel using IWorkSheet.ExportDataTable method and convert the data to a DataTable collection in WPF DataGrid (SfDataGrid). You can then set the DataTable collection as ItemsSource of SfDataGrid. Using this way, you can import the data from Excel to SfDataGrid. Refer the below code example for more details.
C#
private void Button_Click(object sender, RoutedEventArgs e) { ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; IWorkbook workbook = application.Workbooks.Create(1); IWorksheet worksheet = workbook.Worksheets[0]; //Import the data to worksheet. IList<OrderInfo> reports = viewModel.Generate(); worksheet.ImportData(reports, 1, 1, true); // Read data from the worksheet and Export to the DataTable. DataTable customersTable = worksheet.ExportDataTable(1, 1, 15, 5, ExcelExportDataTableOptions.ColumnNames); this.dataGrid.ItemsSource = customersTable; workbook.Close(); excelEngine.Dispose(); }
Refer here for more details about import data from excel to Grid.