Write csv file to string?

[NeilMeredith]

I would like to use the csvhelper to export a list of objects to a csv file in the browser. All I see in the documentation are ways to write directly to a file - can you return the csv file as a string for export?

I tried something like this, but the 'WriteRecords' method is closing the memory stream:

 using (var memStream = new MemoryStream())
            {
                using (var csv = new CsvWriter(new StreamWriter(memStream)))
                {
                    csv.WriteRecords(events);
                    return File(memStream, "text/csv", "Report123.csv");
                }
            }

[JoshClose]

Yes. That is what most of the unit tests do...

using( var stream = new MemoryStream() )
using( var reader = new StreamReader( stream ) )
using( var writer = new StreamWriter( stream ) )
using( var csv = new CsvWriter( writer ) )
{
    csv.WriteRecords( events );
    writer.Flush();
    stream.Position = 0;
    var text = reader.ReadToEnd();
}

Or something similar. I did this from memory so not sure if it'll compile. ;)

[NeilMeredith]

Thanks Josh, that did it. This is a great library!

[JoshClose]

You're welcome.

[JoeDM09]

Found this via google and the answer is a bit old so thought I'd give it an update for anyone else who finds this.

using (var writer = new StringWriter())
using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture, true))
{
	csv.WriteRecord(csvRow);
	csv.Flush();
	var newRecord = writer.ToString();
}