/// <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);
}
}
}
}