Python将json数据写入excel表

Python将json数据写入excel表

import xlwt

json = [{"time": 1605868916, "kw": "携程"},
        {"time": 1605868992, "kw": "丽江"},
        {"time": 1605869065, "kw": "c6179"},
        {"time": 1605869267, "kw": "丽江景点"},
        {"time": 1605869312, "kw": "女童误服近40粒降压药不幸身亡"},
        {"time": 1606112160, "kw": "python爬虫请求头"},
        {"time": 1606112420, "kw": "useragent"},
        {"time": 1606112494, "kw": "手机useragent"},
        {"time": 1606112849, "kw": "谷歌浏览器useragent"},
        {"time": 1606114944, "kw": "百度贴吧"}]

# 创建一个workbook 设置编码
workbook = xlwt.Workbook(encoding='utf-8')
# 创建一个worksheet
worksheet = workbook.add_sheet('Worksheet')

# 写入excel参数对应 行, 列, 值
worksheet.write(0, 0, label='time')
worksheet.write(0, 1, label='kw')

# 循环插入Excel表中
for i in range(len(json)):
    time = json[i]["time"]
    kw = json[i]["kw"]
    worksheet.write(i + 1, 0, label=time)
    worksheet.write(i + 1, 1, label=kw)

# 保存，文件自动创建到项目目录下
workbook.save('Excel.xls')