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