576
社区成员




[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");
}
从下图可以知道,当内容有英文逗号时,会认为是另外一个单元格内容