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