We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to import the data from excel to WPF DataGrid (SfDataGrid)?

Platform: WPF |
Control: SfDataGrid |
Published Date: May 31, 2017 |
Last Revised Date: March 25, 2021

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.

View sample in GitHub.

 

2X faster development

The ultimate WPF UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile