Reading/writing CSV/tab delimited files in c#

Question

I need to read from a CSV/Tab delimited file and write to such a file as well from .net.

The difficulty is that I don't know the structure of each file and need to write the cvs/tab file to a datatable, which the FileHelpers library doesn't seem to support.

I've already written it for Excel using OLEDB, but can't really see a way to write a tab file for this, so will go back to a library.

Can anyone help with suggestions?

Answer 1

Simple example with CsvHelper

using (TextWriter writer = new StreamWriter(filePath)
{
    var csvWriter = new CsvWriter(writer);
    csvWriter.Configuration.Delimiter = "\t";
    csvWriter.Configuration.Encoding = Encoding.UTF8;
    csvWriter.WriteRecords(exportRecords); 
}