Excel zu SQL über System.Data.DataSet

VBC#

using IronXL;
using System;
using System.Data;

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

// Convert the whole Excel WorkBook to a DataSet
DataSet dataSet = workBook.ToDataSet();

foreach (DataTable table in dataSet.Tables)
{
    Console.WriteLine(table.TableName);

    // Enumerate by rows or columns first at your preference
    foreach (DataRow row in table.Rows)
    {
        for (int i = 0 ; i < table.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")

' Convert the whole Excel WorkBook to a DataSet
Dim dataSet As DataSet = workBook.ToDataSet()

For Each table As DataTable In dataSet.Tables
    Console.WriteLine(table.TableName)

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

PM > Install-Package IronXL.Excel

Install-Package IronXL.Excel

Excel zu SQL über System.Data.DataSet

Konvertieren Sie jede XLSX, XLS, XLSM, XLTX, CSV und TSV Datei in eine System.Data.DataTable für vollständige Interoperabilität mit System.Data.SQL oder um eine DataGrid zu befüllen. Dieses DataTable Objekt kann eine Sammlung von Tabellen, Beziehungen und Einschränkungen enthalten.