想要处理用python抓取的数据，并且要导出到excel？-excel爬取数据,excel抓取多页网页数据

python操作excel常用的模块有xlrd,xlrt,是第三方模块,要另外下载

import json

data = {"data":[
{"id":"1","price_data":"2017-01-06","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-02","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-03","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-05","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"},
{"id":"1","price_data":"2017-01-07","nav":"1.516900","cumulativate_nav_withdrawa1":"1.516900"}
]}

json_str = json.dumps(data)
jsonData = json.loads(json_str)
all_data = jsonData["data"]
for item in all_data:
        #导出代码在这e799bee5baa6e79fa5e98193e78988e69d83335里实现
	print item['price_data'],item['nav'],item['cumulativate_nav_withdrawa1']

下载扩展库copy xlrd 读excle xlwt 写excle 直接在百度上搜就能知下载 下载后使用 import xlrd 就可以读excle文件了道 打开文件： xls = xlrd.open_workbook(fileName)

把print出来的，都存到一百个list里。
all_case=['姓名'，度'张三'，'年龄'，'18'...]
b=[]
x=0
y=0
for i in range(0,len(all_case),2):
b = all_case[i:i+2]
for i in b:

ws.write(x,y,i,style)

x+=1
y+=1

x=0

wtbook.save(path_dst)

上面是核心内容，你理解一下问。就是将list变为2个元素一组的小list，然后对小答list按行写入，写完到下一个小list再回到第回一行。
写完发现答没有格式啊。。。注意一下x+=1和里面for是一组。y+=1和x=0和外面的for是一组。