How to import Excel file to DataTable in C# and VB.NET

// Create an instance of the class that imports Excel files 
ExcelDocument workbook = new ExcelDocument();

// Import Excel file to DataTable
DataSet ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\\Samples\\Excel to DataTable.xlsx");
DataTable dataTable = ds.Tables[0];
   
// Display imported DataTable values
for (int row=0; row < dataTable.Rows.Count; row++)
    for (int column=0; column < dataTable.Columns.Count; column++)
           Console.WriteLine("At row " + (row + 1) + ", column " + (column + 1) + " the value is '" + 
                                  dataTable.Rows[row].ItemArray[column] + "'");

' Create an instance of the class that imports Excel files
Dim workbook As New ExcelDocument

' Import Excel file to DataTable
Dim ds As DataSet = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\Samples\Excel to DataTable.xlsx")
Dim dataTable As DataTable = ds.Tables(0)

' Display imported DataTable values
For row As Integer = 0 To dataTable.Rows.Count - 1
    For column As Integer = 0 To dataTable.Columns.Count - 1
        Console.WriteLine("At row " & (row + 1) & ", column " & (column + 1) & _
         " the value is '" & dataTable.Rows(row).ItemArray(column) & "'")
    Next
Next