/// <summary> /// Uses CsvHelper to write a list of objects to a csv /// </summary> /// <param name="data"></param> private void UseCsvHelper(List <TestExcelData> data) { using (var writer = new StreamWriter(txt_Destination.Text)) using (var csvWrtr = new CsvWriter(writer, CultureInfo.InvariantCulture)) { //-- Write headers for csv file foreach (string header in TestExcelData.GetPropertyDisplayNames()) { csvWrtr.WriteField(header); } csvWrtr.NextRecord(); csvWrtr.Configuration.HasHeaderRecord = false; csvWrtr.WriteRecords(data); } }
/// <summary> /// Uses overridden .ToString() for TestExcelData to write a list of objects to a csv /// </summary> /// <param name="data"></param> private void WriteToStreamWithOverride(List <TestExcelData> data) { using (var fileStream = new FileStream(txt_Destination.Text, FileMode.Append)) { using (var strmWrtr = new StreamWriter(fileStream)) { strmWrtr.WriteLine(string.Join(",", TestExcelData.GetPropertyDisplayNames())); //-- Headers foreach (var item in data) { strmWrtr.WriteLine(item); } } } }