CsvHelper wrap all values with quotes

Question

I am using CsvHelper I need to wrap all values with quotes. Is that possible?

Data = is a List

 using (StreamWriter textWriter = new StreamWriter(path))
 {
     textWriter.BaseStream.Write(p, 0, p.Length);
     // var dt = new DataTable();
     var csv = new CsvWriter(textWriter);
     csv.WriteRecords(Data);
     textWriter.Flush();
     textWriter.Close();
 }

Thanks

score 30 · Accepted Answer · answered Jan 03 '19 at 17:25

30

There is a config value called ShouldQuote where you can determine on a field level if it should be quoted.

void Main()
{
    var records = new List<Foo>
    {
        new Foo { Id = 1, Name = "one" },
        new Foo { Id = 2, Name = "two" },
    };

    using (var writer = new StringWriter())
    using (var csv = new CsvWriter(writer))
    {
        csv.Configuration.ShouldQuote = (field, context) => true;
        csv.WriteRecords(records);

        writer.ToString().Dump();
    }
}

public class Foo
{
    public int Id { get; set; }
    public string Name { get; set; }
}

Output:

"Id","Name"
"1","one"
"2","two"

answered Jan 03 '19 at 17:25

Josh Close

22,935
13
92
140

Thanks! Can it work with CsvReader from your tool? – Stu_Dent Jul 11 '21 at 07:40
@Stu_Dent Not sure what you mean. – Josh Close Jul 15 '21 at 18:18
This seems to be outdated. Use the answer from @Nahue Gonzalez. – gtu Feb 24 '23 at 09:27

score 12 · Answer 2 · answered Oct 15 '21 at 07:12

12

From version 25.0.0 up to the date, the way of doing it is:

var config = new CsvConfiguration(CultureInfo.InvariantCulture)
{
    ShouldQuote = args => true
};

answered Oct 15 '21 at 07:12

Nahue Gonzalez

273
4
10

score 2 · Answer 3 · answered Jan 02 '19 at 07:45

Just need to add a configuration object. like this

CsvHelper.Configuration.CsvConfiguration config = new CsvHelper.Configuration.CsvConfiguration();
               config.QuoteAllFields = true;
                var csv = new CsvWriter(textWriter, config);

CsvHelper wrap all values with quotes

3 Answers3

Linked