public static void Main()
using (var stream = new MemoryStream())
var value = new[] { new { A = "A1", B = "B1" }, new {A="A2",B="B2"}};
stream.SaveAs(value: value,excelType:ExcelType.CSV);
bytes = stream.ToArray();
Console.WriteLine(Encoding.UTF8.GetString(bytes));
using (var stream = new MemoryStream(bytes))
var rows = stream.Query(useHeaderRow:true);
Console.WriteLine(JsonConvert.SerializeObject(rows));