How to import data from Excel file and bind it to Grid?

In Certain cases, users may like to read data from excel worksheet and bind it as dataSource for the Grid control. We can achieve this requirement using the Syncfusion.XlsIO namespace.

Solution:

Render the Grid control, by binding DataTable as dataSource using ViewBag.data

In the Controller, we can load and open an existing excel workbook using the Open method of IWorkbook class. We can export the sheet data to data table using the ExportDataTable method of the IWorkSheet and store the returned DataTable object to the ViewBag.data