How to Use C# to Convert Datatable to CSV

using IronXL;

Imports IronXL

// This function demonstrates how to create a DataTable and export it to a CSV file using IronXL.
private void button6_Click(object sender, EventArgs e)
{
    // Create a new DataTable object
    DataTable table = new DataTable();

    // Add a single column named "Example_DataSet" of type string
    table.Columns.Add("Example_DataSet", typeof(string));

    // Add rows to the DataTable
    table.Rows.Add("0");
    table.Rows.Add("1");
    table.Rows.Add("2");
    table.Rows.Add("3");
    table.Rows.Add("1");
    table.Rows.Add("2");
    table.Rows.Add("3");

    // Create a new Excel workbook and set its author metadata
    WorkBook wb = WorkBook.Create(ExcelFileFormat.XLS);
    wb.Metadata.Author = "OJ";

    // Get the default worksheet
    WorkSheet ws = wb.DefaultWorkSheet;

    // Initialize rowCounter for Excel sheet rows
    int rowCount = 1;

    // Loop through each row in the DataTable and add the data to the Excel worksheet
    foreach (DataRow row in table.Rows)
    {
        // Populate worksheet cells with data from DataTable
        ws["A" + (rowCount)].Value = row[0].ToString();
        rowCount++;
    }

    // Save the workbook as a CSV file
    wb.SaveAsCsv("Save_DataTable_CSV.csv", ";"); // Will be saved as: Save_DataTable_CSV.Sheet1.csv
}

' This function demonstrates how to create a DataTable and export it to a CSV file using IronXL.
Private Sub button6_Click(ByVal sender As Object, ByVal e As EventArgs)
	' Create a new DataTable object
	Dim table As New DataTable()

	' Add a single column named "Example_DataSet" of type string
	table.Columns.Add("Example_DataSet", GetType(String))

	' Add rows to the DataTable
	table.Rows.Add("0")
	table.Rows.Add("1")
	table.Rows.Add("2")
	table.Rows.Add("3")
	table.Rows.Add("1")
	table.Rows.Add("2")
	table.Rows.Add("3")

	' Create a new Excel workbook and set its author metadata
	Dim wb As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
	wb.Metadata.Author = "OJ"

	' Get the default worksheet
	Dim ws As WorkSheet = wb.DefaultWorkSheet

	' Initialize rowCounter for Excel sheet rows
	Dim rowCount As Integer = 1

	' Loop through each row in the DataTable and add the data to the Excel worksheet
	For Each row As DataRow In table.Rows
		' Populate worksheet cells with data from DataTable
		ws("A" & (rowCount)).Value = row(0).ToString()
		rowCount += 1
	Next row

	' Save the workbook as a CSV file
	wb.SaveAsCsv("Save_DataTable_CSV.csv", ";") ' Will be saved as: Save_DataTable_CSV.Sheet1.csv
End Sub