爬虫数据存储在excel表通用代码
一、.xls格式
import xlwt
workbook = xlwt.Workbook(encoding='utf8')
sheet = workbook.add_sheet('XXX')
keys = list(XXX[0].keys())
for i,key in zip(range(len(keys)),keys):
sheet.write(0,i,keys)
for row in range(1,len(XXX)+1,1):
for column,key in zip(range(len(keys)),keys):
sheet.write(row,column,XXX[row-1][key])
workbook.save(r"E:\Spyder\python与excel\写入数据\XXX.xls")
注意:excel表的列名与内容要分开写,内容的话先定义行,然后在每一行填充数据。
二、.csv格式
import csv
headers = list(XXX[0].keys())
with open(r"E:\Spyder\python与CSV\写入数据\XXX.csv",'w',
newline='',encoding='utf8') as f:
writer = csv.DictWriter(f,headers,delimiter='|')
writer.writeheader()
writer.writerows(XXX)
newline-->>解决出现空行的问题;
delimiter-->>指定分割符,最好采用【|】,用逗号的话可能产生冲突。