今天在处理python写入csv中文乱码问题，尝试各种办法，百思不得其解，网上找到的最常用的办法就是
1. encoding=’utf-8’：无效
with open('', 'a', encoding='utf-8', newline='') as csvfile:
fieldnames = (['id', 'name', 'age'])
writer = (csvfile, fieldnames=fieldnames)
({'id': '10005', 'name': '张伟', 'age': '32'})
2. encoding=’utf-8-sig’：无效
with open(filename, 'a', newline='', encoding='utf-8-sig') as f: # 中文需要设置成utf-8格式
f_csv = (f)
f_csv.writerow(('城市', '日期', '天气', '风力', '温度', '摄氏度')) # 头部信息
f_csv.writerows(data)
3. 先转码再储存：无效
('utf-8').encode('gbk')
4. 甚至直接以gbk编码写入：无效
f = ("", 'wb', "gbk")
writer = (f)
(["客户名称", "行业类型", "客户联系人", "职位", "联系方式", "邮箱","地址"])
到此为止，中文还是乱码，我甚至开始怀疑我的excel软件是不是坏了， ，我用的是wps，是不是wps需要修改编码方式？
。
WPS：想什么呢，我糖糖WPS怎么可能让你随便转换编码，我又不是Notepad++，我是高贵的office！
终极办法：打开csv源码发现dialect=”excel”
反思一下，是不是因为csv太Low了，于是竟然成功了！！！丝毫不敢代码，赶紧贴出来，以防还有新手朋友摆渡摆到翻船。拿走不谢…
writer = (csvfile, fieldnames=fieldnames, dialect="excel")
贴上源码：
class DictWriter:
def __init__(self, f, fieldnames, restval="", extrasaction="raise",
dialect="excel", *args, **kwds):
= fieldnames # list of keys for the dict
= restval # for writing short dicts
if () not in ("raise", "ignore"):
raise ValueError("extrasaction (%s) must be 'raise' or 'ignore'"
% extrasaction)
= extrasaction
= writer(f, dialect, *args, **kwds)
def writeheader(self):
header = dict(zip(, ))
(header)
def _dict_to_list(self, rowdict):
if == "raise":
wrong_fields = () -
if wrong_fields:
raise ValueError("dict contains fields not in fieldnames: "
+ ", ".join([repr(x) for x in wrong_fields]))
return ((key, ) for key in )
def writerow(self, rowdict):
return (self._dict_to_list(rowdict))
def writerows(self, rowdicts):
return (map(self._dict_to_list, rowdicts))