using ClosedXML.Excel;

using System;

using System.Data;

​

class Program

{

    static void Main()

    {

        DataTable dataTable = new DataTable();

        dataTable.Columns.Add("Name", typeof(string));

        dataTable.Columns.Add("Sold", typeof(int));

​

        dataTable.Rows.Add("Cheesecake", 14);

        dataTable.Rows.Add("Medovik", 6);

        dataTable.Rows.Add("Muffin", 10);

​

        using (var wb = new XLWorkbook())

        {

            var ws = wb.AddWorksheet();

            ws.Cell("B3").InsertData(dataTable);

            // wb.SaveAs("Demo-Bulk-Insert-Data-DataTable.xlsx");

        }

​

        Console.WriteLine("Excel file created successfully!");

    }

}

​