分享几个常用的数据导出函数
所有函数参数adress赋值为目标地址的字符串,参数dicts赋值为字典的列表,参数name赋值为excel中sheet的名字
1.写入txt文件
#将数据写入txt文件
def txt_write(adress,dicts):
file = open(r'{}'.format(adress),'w',encoding='utf8')
for dic in dicts:
keys = list(dic.keys())
values = list(dic.values())
for key,value in zip(keys,values):
file.write(f'{key}:{value}\n')
file.write(f'{"="*50}\n')
file.close()
2.写入excel
#将数据写入excel文件
import xlwt
def excel_write(adress,dicts,sheet_name):
workbook = xlwt.Workbook(encoding= 'utf8')
sheet = workbook.add_sheet(sheet_name)
#列名
keys = list(dicts[0].keys())
for i,key in zip(range(len(keys)),keys):
sheet.write(0,i,key)
#内容
for row in range(1,len(dicts)+1,1):
for col,key in zip(range(len(keys)),keys):
sheet.write(row,col,dicts[row-1][key])
workbook.save(r'{}'.format(adress))
3.写入csv
#将数据写入csv文件
import csv
def csv_write(adress,dicts):
keys = list(dicts[0].keys())
#定义csv文件的表头【列名】
headers = []
values = []
for i in range(len(keys)):
headers.append(keys[i])
for j in range(len(dicts)):
value = dicts[j].values()
values.append(value)
with open(r'{}'.format(adress),'w',encoding='utf8')as f:
#实例化一个写对象
writer = csv.writer(f)
#写入列名
writer.writerow(headers)
#写入内容
writer.writerows(values)