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