【python3】生成csv文件中文乱码

深度链接 / 2023-12-06 21:48:31 / 209

python3.4生成csv文件用Excel打开时中文乱码

1、乱码重现

#创建csv_test.py
[root@wrx python3]# vim csv_test.py
代码内容如下:
#!/usr/local/bin/python3
# -*- coding=UTF-8 -*-
import csv

data = ["W","R","X","未","知","数"]
with open("csv_text.csv","a") as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(data)
        csvfile.close()

2、打开生成的csv_text.csv,中文字符出现乱码

image.png

3、修改后的代码如下

#!/usr/local/bin/python3
# -*- coding=UTF-8 -*-
import csv

data = ["W","R","X","未","知","数"]
with open("csv_text.csv","a",encoding="gbk") as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(data)
        csvfile.close()

4、修改后

blob.png