####1、python创建excel
def creat_csv(csvname):
file = open(csvname, 'wb')
writer = csv.writer(file)
file.close
####2、python往csv中写中文
import csv
import codecs
csvfile = file('csv_test.csv', 'wb')
csvfile.write(codecs.BOM_UTF8)
writer = csv.writer(csvfile)
list = ['姓名', '年龄', '电话']
writer.writerow(list)
csvfile.close()
python 中使用writerow 往excel中写入数据时,出现空白行交替的解决方案:https://www.crifan.com/python_csv_writer_writerow_redundant_new_line/?utm_source=tuicool&utm_medium=referral ,简而言之,文件要以二进制的方式打开
参考网址:https://www.cnblogs.com/vsivn/p/6115537.html
参考网址:https://www.jb51.net/article/95445.htm