are there any CSV readers/writer lib's in c#

Question

are there any CSV readers/writer lib's in c#

Answer 1

http://knab.ws/blog/index.php?/archives/3-CSV-file-parser-and-writer-in-C-Part-1.html
http://www.codeproject.com/KB/database/Cs%5FCSV%5Fimport%5Fexport.aspx

Answer 2

Yes - though I assume you're actually asking for specifics?

Try FileHelpers

Answer 3

There are dozens.

http://www.filehelpers.com/ is one of the most common.

I should say that I find Filehelpers restrictive in some scenarios, and instead use The Fast CSV Reader. In my experience, if you dont know the format of your CSV file or import mapping until runtime - this is the better library to use.

Answer 4

Sebastien Lorion has a great CSV reader on CodeProject called A Fast CSV Reader. Probably one of the best for C# and it's free.

As far as writing, just use StreamWriter!

Here is some boilerplate code for writing a DataGridView to file:

private void exportDGVToCSV(string filename)
    {
        if(dataGridView1.Columns.Count != 0) {

            StringBuilder myString = new StringBuilder();

            if (File.Exists(FilePath + "file"))
            {
                File.Delete(FilePath + "file");
            }

            StreamWriter sw = new StreamWriter(filename, true);

            // loop through each row of our DataGridView

            foreach(DataGridViewRow row in dataGridView1.Rows) {
                foreach(DataGridViewCell cell in row.Cells) {               
                    myString.Append(cell.Value + ",");
                    myString.Append("\r\n");

                }
            }
            sw.WriteLine(myString.ToString());
            sw.Close();

            GC.Collect();

        }
    }

Answer 5

There are a couple of options, right in the framework itself.

One of the easiest is to Reference Microsoft.VisualBasic, then use TextFieldParser. It is a fully functional CSV reader in the core framework.

Another good alternative is to use datasets to read CSV files.

Answer 6

Try CsvHelper. It's as easy to use as FastCsvReader and does writing also. I've been very happy with FastCsvReader in the past, but I needed something that does writing also, and wasn't happy with FileHelpers.

Reading:

var csv = new CsvReader( stream );
var myCustomTypeList = csv.GetRecords<MyCustomType>();

Writing:

var csv = new CsvWriter( stream );
csv.WriteRecords( myCustomTypeList );