Excel zu SQL und DataGrid über 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 zu SQL und DataGrid über DataTable

Konvertieren Sie XLSX, XLS, XLSM, XLTX, CSV und TSV Dateien in eine System.Data.DataTable für vollständige Interoperabilität mit System.Data.SQL oder um eine DataGrid zu befüllen.

Geben Sie true in die ToDataTable Methode ein, um die erste Zeile als Spaltennamen der Tabelle festzulegen. Der DataTable kann eine DataGrid füllen.