How to Import and Export as DataSet

using IronXL;
using System.Data;

// Create an instance of a DataSet to hold DataTables
DataSet dataSet = new DataSet();

// Create an instance of a WorkBook and specify the Excel file format
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Populate the DataSet with a DataTable (this is an example setup)
// Create a new DataTable and define its schema
DataTable table = new DataTable("Sample");
table.Columns.Add("Column1");
table.Columns.Add("Column2");

// Add rows with data to the DataTable
table.Rows.Add("Value1", "Value2");

// Add the DataTable to the DataSet
dataSet.Tables.Add(table);

// Load the DataSet into the WorkBook
// This transforms each DataTable within the DataSet into a worksheet in the WorkBook
workBook.LoadDataSet(dataSet);

// Further operations such as saving the WorkBook to a file can be done here if needed
// For example: workBook.SaveAs("output.xlsx");

Imports IronXL
Imports System.Data

' Create an instance of a DataSet to hold DataTables
Private dataSet As New DataSet()

' Create an instance of a WorkBook and specify the Excel file format
Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

' Populate the DataSet with a DataTable (this is an example setup)
' Create a new DataTable and define its schema
Private table As New DataTable("Sample")
table.Columns.Add("Column1")
table.Columns.Add("Column2")

' Add rows with data to the DataTable
table.Rows.Add("Value1", "Value2")

' Add the DataTable to the DataSet
dataSet.Tables.Add(table)

' Load the DataSet into the WorkBook
' This transforms each DataTable within the DataSet into a worksheet in the WorkBook
workBook.LoadDataSet(dataSet)

' Further operations such as saving the WorkBook to a file can be done here if needed
' For example: workBook.SaveAs("output.xlsx");

using IronXL;
using System.Data;

// This code demonstrates how to create a new Excel workbook and worksheet
// using the IronXL library, and then export the workbook as a DataSet.
class ExcelHandler
{
    static void Main(string[] args)
    {
        // Create a new Excel WorkBook document with specified format
        WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

        // Create a blank WorkSheet and add it to the workbook
        WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

        // Optionally, you can add data to the worksheet here
        // For example, adding sample data to cell A1:
        workSheet["A1"].Value = "Sample Data";

        // Export the workbook as a DataSet
        DataSet dataSet = workBook.ToDataSet();

        // Now 'dataSet' can be used to manipulate or inspect the data programmatically
        // For example, iterating over each table and printing its data:
        foreach (DataTable table in dataSet.Tables)
        {
            foreach (DataRow row in table.Rows)
            {
                foreach (var item in row.ItemArray)
                {
                    Console.Write(item + "\t");
                }
                Console.WriteLine();
            }
        }
    }
}

Imports Microsoft.VisualBasic
Imports IronXL
Imports System.Data

' This code demonstrates how to create a new Excel workbook and worksheet
' using the IronXL library, and then export the workbook as a DataSet.
Friend Class ExcelHandler
	Shared Sub Main(ByVal args() As String)
		' Create a new Excel WorkBook document with specified format
		Dim workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

		' Create a blank WorkSheet and add it to the workbook
		Dim workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

		' Optionally, you can add data to the worksheet here
		' For example, adding sample data to cell A1:
		workSheet("A1").Value = "Sample Data"

		' Export the workbook as a DataSet
		Dim dataSet As DataSet = workBook.ToDataSet()

		' Now 'dataSet' can be used to manipulate or inspect the data programmatically
		' For example, iterating over each table and printing its data:
		For Each table As DataTable In dataSet.Tables
			For Each row As DataRow In table.Rows
				For Each item In row.ItemArray
					Console.Write(item & vbTab)
				Next item
				Console.WriteLine()
			Next row
		Next table
	End Sub
End Class