public async Task TestJsonValues() { var csvData = "A;B" + Environment.NewLine + "42;\"{\"\"IntValue\"\":42,\"\"StrValue\"\":\"\"Forty-Two\"\"}\"" + Environment.NewLine + "5;\"{\"\"IntValue\"\":5,\"\"StrValue\"\":\"\"Five\"\"}\""; var sb = new StringBuilder(); using var csvWriter = new CsvWriter(sb); var csvTableWriter = new CsvTableWriter(csvWriter); csvTableWriter.AddConverter <CustomType>(new CustomTypeConverter()); await csvTableWriter.WriteHeadersAsync("A", "B"); Assert.Equal(2, csvTableWriter.Headers.Count); csvTableWriter.SetValue("A", 42); csvTableWriter.SetValue("B", new CustomType { IntValue = 42, StrValue = "Forty-Two" }); await csvTableWriter.WriteAsync(); csvTableWriter.SetValue("A", 5); csvTableWriter.SetValue("B", new CustomType { IntValue = 5, StrValue = "Five" }); await csvTableWriter.WriteAsync(); Assert.Equal(csvData, sb.ToString()); }
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()); }