Excel vers SQL et DataGrid via DataTable

VBC#

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
Dim workBook As WorkBook = WorkBook.Load("sample.xlsx")

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

' Convert the worksheet to DataTable
Dim 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
Next

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Excel vers SQL et DataGrid via DataTable

Convertissez les fichiers XLSX, XLS, XLSM, XLTX, CSV et TSV en un System.Data.DataTable pour une interopérabilité complète avec System.Data.SQL ou pour remplir un DataGrid.

Entrez true dans la méthode ToDataTable pour définir la première ligne comme noms de colonnes de la table. Le DataTable peut remplir un DataGrid.