![在 Excel 中打开然后保存 CSV 文件时,保存格式不同](https://linux22.com/image/1572226/%E5%9C%A8%20Excel%20%E4%B8%AD%E6%89%93%E5%BC%80%E7%84%B6%E5%90%8E%E4%BF%9D%E5%AD%98%20CSV%20%E6%96%87%E4%BB%B6%E6%97%B6%EF%BC%8C%E4%BF%9D%E5%AD%98%E6%A0%BC%E5%BC%8F%E4%B8%8D%E5%90%8C.png)
在记事本中打开示例 CSV 文件显示格式如下:
"ds","y"
"2007-12-10",9.59076113897809
"2007-12-11",8.51959031601596
"2007-12-12",8.18367658262066
"2007-12-13",8.07246736935477
"2007-12-14",7.8935720735049
"2007-12-15",7.78364059622125
"2007-12-16",8.41405243249672
"2007-12-17",8.82922635473185
"2007-12-18",8.38251828808963
"2007-12-19",8.06965530688617
"2007-12-20",7.87929148508227
"2007-12-21",7.76174498465891
"2007-12-22",7.52940645783701
"2007-12-23",8.38526052015541
"2007-12-24",8.62011072542292
使用 Excel 打开文件然后保存文件时,它将保存为以下内容(文件格式 CSV [逗号分隔])。
它在记事本中的样子如下:
"ds,""y"""
2007-12-10,9.59076113897809
2007-12-11,8.51959031601596
2007-12-12,8.18367658262066
2007-12-13,8.07246736935477
2007-12-14,7.8935720735049
2007-12-15,7.78364059622125
2007-12-16,8.41405243249672
2007-12-17,8.82922635473185
2007-12-18,8.38251828808963
2007-12-19,8.06965530688617
2007-12-20,7.87929148508227
2007-12-21,7.76174498465891
2007-12-22,7.52940645783701
2007-12-23,8.38526052015541
2007-12-24,8.62011072542292
如何保存打开的文件并保留原始格式?