Category / Section
How to import the data from excel to WinForms 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 WinForms DataGrid (SfDataGrid). You can then set the DataTable collection as DataSource of WinForms DataGrid (SfDataGrid). Using this way, you can import the data from Excel to WinForms DataGrid (SfDataGrid). 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();
}
Refer here for more details about import data from excel to Grid.
