數(shù)據(jù)

[{"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}]# 獲取ｊｓｏｎ數(shù)據(jù) 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 = []# 循環(huán)里面的字典，將value作為數(shù)據(jù)寫入進(jìn)去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)

過程中報(bào)錯(cuò)

原因

只裝了pip install tablib ；導(dǎo)致安裝tablib庫(kù)不全面

解決

pip install tablib[all]

結(jié)果

查看生成的excel文件

總結(jié)

以上是生活随笔為你收集整理的python3实现json转excel的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。