How to Convert a Data Table to an Excel File

using System;
using System.Data;
using IronXL;

namespace DataTableToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            // Method call to convert DataTable to Excel
            ConvertDataTableToExcel("DataTable.xlsx");
        }

        /// <summary>
        /// Converts a DataTable to an Excel file.
        /// </summary>
        /// <param name="fileName">The name of the Excel file to save.</param>
        static void ConvertDataTableToExcel(string fileName)
        {
            // Initialize a new DataTable with columns
            DataTable table = new DataTable();
            table.Columns.Add("ID", typeof(int));
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Age", typeof(int));

            // Populate the DataTable with sample data
            table.Rows.Add(1, "John Doe", 30);
            table.Rows.Add(2, "Jane Smith", 25);
            table.Rows.Add(3, "Sam Brown", 22);

            // Create a new workbook and get the first worksheet
            WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);
            WorkSheet sheet = workbook.CreateWorkSheet("Sheet1");

            // Adding column headers
            for (int i = 0; i < table.Columns.Count; i++)
            {
                sheet[$"A{1}"].Value = table.Columns[i].ColumnName;
            }

            // Populate the worksheet with data table rows
            for (int rowIndex = 0; rowIndex < table.Rows.Count; rowIndex++)
            {
                for (int columnIndex = 0; columnIndex < table.Columns.Count; columnIndex++)
                {
                    sheet[$"{(char)('A' + columnIndex)}{(rowIndex + 2)}"].Value = table.Rows[rowIndex][columnIndex].ToString();
                }
            }

            // Save the workbook to the specified file
            workbook.SaveAs(fileName);
            Console.WriteLine($"Excel file '{fileName}' created successfully.");
        }
    }
}

Imports System
Imports System.Data
Imports IronXL

Namespace DataTableToExcel
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			' Method call to convert DataTable to Excel
			ConvertDataTableToExcel("DataTable.xlsx")
		End Sub

		''' <summary>
		''' Converts a DataTable to an Excel file.
		''' </summary>
		''' <param name="fileName">The name of the Excel file to save.</param>
		Private Shared Sub ConvertDataTableToExcel(ByVal fileName As String)
			' Initialize a new DataTable with columns
			Dim table As New DataTable()
			table.Columns.Add("ID", GetType(Integer))
			table.Columns.Add("Name", GetType(String))
			table.Columns.Add("Age", GetType(Integer))

			' Populate the DataTable with sample data
			table.Rows.Add(1, "John Doe", 30)
			table.Rows.Add(2, "Jane Smith", 25)
			table.Rows.Add(3, "Sam Brown", 22)

			' Create a new workbook and get the first worksheet
			Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
			Dim sheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")

			' Adding column headers
			For i As Integer = 0 To table.Columns.Count - 1
				sheet($"A{1}").Value = table.Columns(i).ColumnName
			Next i

			' Populate the worksheet with data table rows
			For rowIndex As Integer = 0 To table.Rows.Count - 1
				For columnIndex As Integer = 0 To table.Columns.Count - 1
					sheet($"{ChrW(AscW("A"c) + columnIndex)}{(rowIndex + 2)}").Value = table.Rows(rowIndex)(columnIndex).ToString()
				Next columnIndex
			Next rowIndex

			' Save the workbook to the specified file
			workbook.SaveAs(fileName)
			Console.WriteLine($"Excel file '{fileName}' created successfully.")
		End Sub
	End Class
End Namespace