How to export DataTable to Excel file in C# and VB.NET

// Create and populate the datatable
DataTable dataTable = new DataTable();
DataColumn[] columns = {new DataColumn("ID"), new DataColumn("Value")};
Object[] row1 = {"1", "Value1"};
Object[] row2 = {"2", "Value2"};
Object[] row3 = {"3", "Value3"};
dataTable.Columns.AddRange(columns);
dataTable.Rows.Add(row1);
dataTable.Rows.Add(row2);
dataTable.Rows.Add(row3);

// Create a dataset that keeps the datatable
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);

// Export the dataset and its datatable to Excel file
EasyXLS.ExcelDocument workbook = new EasyXLS.ExcelDocument();
workbook.easy_WriteXLSXFile_FromDataSet(
         "C:\\Samples\\DataTable to Excel.xlsx",
         dataSet, 
         new EasyXLS.ExcelAutoFormat(EasyXLS.Constants.Styles.AUTOFORMAT_EASYXLS1), 
         "DataTable");

// Dispose memory
workbook.Dispose();
dataSet.Dispose();

' Create and populate the datatable
Dim dataTable As DataTable = New DataTable
Dim columns As DataColumn() = {New DataColumn("ID"), New DataColumn("Value")}
Dim row1 As Object() = {"1", "Value1"}
Dim row2 As Object() = {"2", "Value2"}
Dim row3 As Object() = {"3", "Value3"}
dataTable.Columns.AddRange(columns)
dataTable.Rows.Add(row1)
dataTable.Rows.Add(row2)
dataTable.Rows.Add(row3)

' Create a dataset that keeps the datatable
Dim dataSet As DataSet = New DataSet
dataSet.Tables.Add(dataTable)

' Export the dataset and its datatable to Excel file
Dim workbook As EasyXLS.ExcelDocument = New EasyXLS.ExcelDocument

workbook.easy_WriteXLSXFile_FromDataSet( _
         "C:\\Samples\\DataTable to Excel.xlsx", _
         dataSet, _
         New EasyXLS.ExcelAutoFormat(EasyXLS.Constants.Styles.AUTOFORMAT_EASYXLS1), _
         "DataTable")

' Dispose memory
workbook.Dispose()
dataSet.Dispose()