How to Import CSV To Datatable in C#

using System;
using System.Data;
using System.IO;
using IronXL;

namespace CSVImporter
{
    public class CSVToDataTable
    {
        // This static method imports a CSV file and returns it as a DataTable.
        public static DataTable ImportCSVToDataTable(string filePath)
        {
            // Check if the specified file exists
            if (!File.Exists(filePath))
                throw new FileNotFoundException("The CSV file could not be found.", filePath);

            try
            {
                // Load the CSV file into a workbook
                WorkBook workbook = WorkBook.LoadCSV(filePath, fileDelimeter: ',');

                // Get the first worksheet from the workbook
                WorkSheet sheet = workbook.WorkSheets[0];

                // Convert the WorkSheet to a DataTable
                DataTable dataTable = sheet.ToDataTable(true); // 'true' to include column names

                return dataTable;
            }
            catch (Exception ex)
            {
                Console.WriteLine("An error occurred while importing the CSV file: " + ex.Message);
                return null;
            }
        }

        static void Main(string[] args)
        {
            string filePath = "path/to/your/csvfile.csv";

            // Import CSV file as DataTable
            DataTable dataTable = ImportCSVToDataTable(filePath);

            if (dataTable != null)
            {
                // Iterate through the rows of the DataTable and print them to the console
                foreach (DataRow row in dataTable.Rows)
                {
                    foreach (var item in row.ItemArray)
                    {
                        Console.Write(item + "\t");
                    }
                    Console.WriteLine();
                }
            }
        }
    }
}

Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.IO
Imports IronXL

Namespace CSVImporter
	Public Class CSVToDataTable
		' This static method imports a CSV file and returns it as a DataTable.
		Public Shared Function ImportCSVToDataTable(ByVal filePath As String) As DataTable
			' Check if the specified file exists
			If Not File.Exists(filePath) Then
				Throw New FileNotFoundException("The CSV file could not be found.", filePath)
			End If

			Try
				' Load the CSV file into a workbook
				Dim workbook As WorkBook = WorkBook.LoadCSV(filePath, fileDelimeter:= ","c)

				' Get the first worksheet from the workbook
				Dim sheet As WorkSheet = workbook.WorkSheets(0)

				' Convert the WorkSheet to a DataTable
				Dim dataTable As DataTable = sheet.ToDataTable(True) ' 'true' to include column names

				Return dataTable
			Catch ex As Exception
				Console.WriteLine("An error occurred while importing the CSV file: " & ex.Message)
				Return Nothing
			End Try
		End Function

		Shared Sub Main(ByVal args() As String)
			Dim filePath As String = "path/to/your/csvfile.csv"

			' Import CSV file as DataTable
			Dim dataTable As DataTable = ImportCSVToDataTable(filePath)

			If dataTable IsNot Nothing Then
				' Iterate through the rows of the DataTable and print them to the console
				For Each row As DataRow In dataTable.Rows
					For Each item In row.ItemArray
						Console.Write(item & vbTab)
					Next item
					Console.WriteLine()
				Next row
			End If
		End Sub
	End Class
End Namespace