How to import the data from excel to WinForms DataGrid?

2 mins read

You can read the data from Excel using IWorkSheet.ExportDataTable method and convert the data to a DataTable collection in WinForms DataGrid (SfDataGrid). You can then set the DataTable collection as DataSource of DataGrid. Using this way, you can import the data from Excel to DataGrid. Refer the below code example for more details.

private void btnImportData_Click(object sender, EventArgs 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.
    ObservableCollection<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.sfDataGrid.DataSource = customersTable;
    workbook.Close();
    excelEngine.Dispose();
}

Shows import the data from excel to SfDataGrid

Take a moment to peruse the WinForms DataGrid - Import To Excel documentation, where you can find about import to excel.

View sample in GitHub.

Did you find this information helpful?

Yes

Comments (0)

How to import the data from excel to WinForms DataGrid?

Access denied