public async Task TestStronglyTypedValues() { var csvData = "A;B;C;D" + Environment.NewLine + "22;Text;true;01.01.2010" + Environment.NewLine + "-31;A long text;false;20.01.2050" + Environment.NewLine + "55;\"A text with ;\";;31.07.1971"; var sb = new StringBuilder(); using var csvWriter = new CsvWriter(sb); var csvTableWriter = new CsvTableWriter(csvWriter); csvTableWriter.SetFormats <DateTime>("dd.MM.yyyy"); csvTableWriter.SetTrueFalseString <bool>("true", "false"); await csvTableWriter.WriteHeadersAsync("A", "B", "C", "D"); Assert.Equal(4, csvTableWriter.Headers.Count); csvTableWriter.SetValue("A", 22); csvTableWriter.SetValue("B", "Text"); csvTableWriter.SetValue("C", true); csvTableWriter.SetValue("D", new DateTime(2010, 1, 1)); await csvTableWriter.WriteAsync(); csvTableWriter.SetValue("A", -31); csvTableWriter.SetValue("B", "A long text"); csvTableWriter.SetValue("C", false); csvTableWriter.SetValue("D", new DateTime(2050, 1, 20)); await csvTableWriter.WriteAsync(); Assert.True(csvTableWriter.TrySetValue("A", 55)); Assert.True(csvTableWriter.TrySetValue("B", "A text with ;")); Assert.True(csvTableWriter.TrySetValue("C", null)); Assert.True(csvTableWriter.TrySetValue("D", new DateTime(1971, 7, 31))); await csvTableWriter.WriteAsync(); Assert.Equal(csvData, sb.ToString()); }
public async Task TestStronglyTypedWriter() { var csvData = "A;B;C;D" + Environment.NewLine + "22;Text;true;01.01.2010" + Environment.NewLine + "-31;A long text;false;20.01.2050" + Environment.NewLine + "55;\"A text with ;\";;31.07.1971"; var sb = new StringBuilder(); using var csvWriter = new CsvWriter(sb); var csvTableWriter = new CsvTableWriter(csvWriter); csvTableWriter.SetFormats <DateTime>("dd.MM.yyyy"); csvTableWriter.SetTrueFalseString <bool>("true", "false"); await csvTableWriter.WriteHeadersAsync <SampleObject>(x => new { x.A, x.B, x.C, x.D }); Assert.Equal(4, csvTableWriter.Headers.Count); await csvTableWriter.WriteAsync(new SampleObject() { A = 22, B = "Text", C = true, D = new DateTime(2010, 1, 1) }); await csvTableWriter.WriteAsync(new SampleObject() { A = -31, B = "A long text", C = false, D = new DateTime(2050, 1, 20) }); await csvTableWriter.WriteAsync(new SampleObject() { A = 55, B = "A text with ;", C = null, D = new DateTime(1971, 7, 31) }); Assert.Equal(csvData, sb.ToString()); }