excel - 用双引号括起来的csv文件不去除引号

Question

我正在从我的 Web 服务器生成 csv 下载，为了安全起见，我用双引号将每个字段括起来。

IE。

"Field1","Field2","Field3","Field4"
"row1_field1","row1_field2","row1_field3","row1_field4"
"row2_field1","row2_field2","row2_field3","row2_field4"

问题是，当文件在 Excel 中打开时，它不会去掉所有引号......因此，某些字段显示为:row1_field1 而其他字段显示为“row1_field2”

我没有做什么来确保 excel 去掉所有周围的引号？

Answer 1

确保逗号周围没有空格。所以以下应该工作:

"row1_field1","row1_field2","row1_field3","row1_field4"
"row2_field1","row2_field2","row2_field3","row2_field4"

但这将显示在适当的引号中:

"row1_field1", "row1_field2", "row1_field3", "row1_field4"
"row2_field1", "row2_field2", "row2_field3", "row2_field4"