Export Excel Data to DataTable in C#

export-excel-to-datatable-non-strongly.cs

// Create a file stream containing the Excel file to be opened
FileStream fstream = new FileStream("Excel.xlsx", FileMode.Open);

// Instantiate a Workbook object
//Opening the Excel file through the file stream
Workbook workbook = new Workbook(fstream);

// Access the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Export the contents of 2 rows and 2 columns starting from 1st cell to DataTable
DataTable dataTable = worksheet.Cells.ExportDataTableAsString(0, 0, 2, 2, true);

// Bind the DataTable with DataGrid
dataGridView1.DataSource = dataTable;

// Close the file stream to free all resources
fstream.Close();

export-excel-to-datatable.cs

// Create a file stream containing the Excel file to be opened
FileStream fstream = new FileStream("Excel.xlsx", FileMode.Open);

// Instantiate a Workbook object
//Opening the Excel file through the file stream
Workbook workbook = new Workbook(fstream);

// Access the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Export the contents of 2 rows and 2 columns starting from 1st cell to DataTable
DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0,2, 2, true);

// Bind the DataTable with DataGrid
dataGridView1.DataSource = dataTable;

// Close the file stream to free all resources
fstream.Close();