python3实现json转excel

数据

[ { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" }, { "name":"flten", "category":"com", "count":1, "location":"上海", "time":"2020-7-2" } ]

代码

import json import tablib # json.text文件的格式： [{"a":1},{"a":2},{"a":3},{"a":4},{"a":5}] # 获取ｊｓｏｎ数据 with open('json.txt', 'r',encoding='utf-8') as f: rows = json.load(f) # print(rows) # 将json中的key作为header, 也可以自定义header（列名） header=tuple([ i for i in rows[0].keys()]) # print('header',header) data = [] # 循环里面的字典，将value作为数据写入进去 for row in rows: body = [] for v in row.values(): body.append(v) data.append(tuple(body)) # print('data',data) data = tablib.Dataset(*data,headers=header) print('data',data) open('data.xlsx', 'wb').write(data.xlsx)

过程中报错

原因

只装了pip install tablib ；导致安装tablib库不全面

解决

pip install tablib[all]

结果

查看生成的excel文件