Excel to SQL and DataGrid via DataTable

VB C#

using IronXL;
using System;
using System.Data;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);

// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
    for (int i = 0 ; i < dataTable.Columns.Count ; i++)
    {
        Console.Write(row[i]);
    }
}

Imports IronXL
Imports System
Imports System.Data

' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")

' Select default sheet
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Convert the worksheet to DataTable
Private dataTable As DataTable = workSheet.ToDataTable(True)

' Enumerate by rows or columns first at your preference
For Each row As DataRow In dataTable.Rows
	For i As Integer = 0 To dataTable.Columns.Count - 1
		Console.Write(row(i))
	Next i
Next row

Install-Package IronXL.Excel

Excel to SQL and DataGrid via DataTable

Convert XLSX, XLS, XLSM, XLTX, CSV and TSV file to a System.Data.DataTable for full interoperability with System.Data.SQL or to populate a DataGrid.

Input true to ToDataTable method to set the first row as column names of the table. The DataTable can populate a DataGrid.

How to Convert Excel to SQL DataTable in C#

Install an Excel library to convert Excel to SQL DataTable.
Select the default Worksheet
Create a DataTable from data using ToDataTable.
Process values iteratively.

using IronXL;

public class ExcelToDataTable
{
    public static DataTable ConvertExcelToDataTable(string filePath)
    {
        WorkBook workbook = WorkBook.Load(filePath);
        WorkSheet sheet = workbook.DefaultWorkSheet;
        DataTable dataTable = sheet.ToDataTable(true);
        return dataTable;
    }
}

using IronXL;

public class ExcelToDataTable
{
    public static DataTable ConvertExcelToDataTable(string filePath)
    {
        WorkBook workbook = WorkBook.Load(filePath);
        WorkSheet sheet = workbook.DefaultWorkSheet;
        DataTable dataTable = sheet.ToDataTable(true);
        return dataTable;
    }
}

Imports IronXL

Public Class ExcelToDataTable
	Public Shared Function ConvertExcelToDataTable(ByVal filePath As String) As DataTable
		Dim workbook As WorkBook = WorkBook.Load(filePath)
		Dim sheet As WorkSheet = workbook.DefaultWorkSheet
		Dim dataTable As DataTable = sheet.ToDataTable(True)
		Return dataTable
	End Function
End Class

$vbLabelText $csharpLabel