【.net core】导出数据到csv时，发现一个有意思的地方

[全栈小5]

1、导出代码

[HttpGet]
public IActionResult Export()
{
    StringBuilder sb = new StringBuilder();
    sb.Append("编号,标题,描述 \r\n");

    int id = 1;
    string title = "测试标题";
    string description = "测试描述,描述里面有英文逗号，有中文逗号！";
    sb.Append(id + "," + title + "," + description + " \r\n");

    MemoryStream memoryStream = new MemoryStream();
    StreamWriter sw = new StreamWriter(memoryStream, System.Text.Encoding.UTF8);
    sw.Write(sb.ToString());
    sw.Flush();
    memoryStream.Position = 0;

    return File(memoryStream, "text/comma-separated-values", $"DLZ{DateTime.Now.ToString("yyyyMMddHHmmss")}.csv");
}

2、效果

从下图可以知道，当内容有英文逗号时，会认为是另外一个单元格内容