Import Excel file to DataSet in .NET

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

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

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

' Import Excel file to DataSet
Dim dataSet As DataSet = _
        workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\Samples\Tutorial09.xlsx")

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

// Create an instance of the class that imports Excel files
ExcelDocument ^workbook = gcnew ExcelDocument();
 
// Import Excel file to DataSet
DataSet ^ds = 
        workbook->easy_ReadXLSXActiveSheet_AsDataSet("C:\\Samples\\Tutorial09.xlsx");

// Display imported DataSet values
DataTable ^dt = ds->Tables[0];
StringBuilder ^str;
for (int row=0; row < dt->Rows->Count; row++)
{
   for (int column=0; column < dt->Columns->Count; column++)
   {
      str = gcnew StringBuilder();
      str->Append(String::Concat("At row " (row + 1).ToString(), ", column " 
                                                (column + 1).ToString()));
      str->Append(String::Concat(" the value is '" 
                  Convert::ToString(dt->Rows[row]->ItemArray[column]), "'"));
      Console::WriteLine(str);
   }
}

# Create an instance of the class that imports Excel files
workbook = ExcelDocument()

# Import Excel file to DataSet
ds = workbook.easy_ReadXLSXActiveSheet_AsDataSet("C:\\Samples\\Tutorial09.xlsx")

# Display imported DataSet values
dt = ds.Tables[0]
for row in range(dt.Rows.Count):
    for column in range(dt.Columns.Count):
        print("At row " + str(row + 1) + ", column " + str(column + 1) +
            " the value is '" + dt.Rows[row].ItemArray[column] + "'")

Click here to see Continuous Code Listing