python - 无法将列表的值插入 csv 的分隔行中

Question

我无法将列表的每个值插入到 CSV 的不同行/行中。它只转到一行..我做错了什么？谢谢你。

formatted_lines = ['BR', 'BRQSB', 'BRQS', 'BRQSBWL9', 'CN', 'CNSHAWLT9001', 'CNS', 'DEA']

pathsave = 'C:\\Users\\user\\Desktop\\Py\\test.csv' 

import csv

with open(pathsave, "w", newline="") as myfile:
    wr = csv.writer(myfile, quoting=csv.QUOTE_ALL)
    wr.writerow(formatted_lines)

我想要的输出是一个 csv 格式:

BR
BRQSB
BRQS
BRQSBWL9
...

Answer 1

您需要将换行符\n指定为delimiter

formatted_lines = ['BR', 'BRQSB', 'BRQS', 'BRQSBWL9', 'CN', 'CNSHAWLT9001', 'CNS', 'DEA']

import csv

with open((pathsave, 'w') as f:
    writer = csv.writer(f, delimiter='\n')
    writer.writerow(formatted_lines)

因为换行符与平台相关，所以您可以使用 os.linesep相反。

import os
with open((pathsave, 'w') as f:
    writer = csv.writer(f, delimiter=os.linesep)
    writer.writerow(formatted_lines)