示例代码
import csv
fieldnames=["A","B","C"]#数据列名
dicts=[
{'A': '1', 'B': '2', 'C':3},
{'A': '2', 'B': '3', 'C':4},
{'A': '3', 'B': '4', 'C':5},
{'A': '4', 'B': '5', 'C':6},
{'A': '5', 'B': '6', 'C':7},
{'A': '9', 'B': '7', 'C':8},
]
with open('test.csv', 'a', newline='',encoding='utf_8_sig') as f:
writer = csv.DictWriter(f,fieldnames=fieldnames)
writer.writeheader()
writer.writerows(dicts)
实例代码: