python解析json写入excel
时间: 2023-08-26 12:15:16 浏览: 69
要将Python解析JSON数据并写入Excel文件,可以使用xlwt库来创建Excel工作表,并使用json库读取JSON数据。以下是一个示例代码:
```python
import xlwt
import json
def json_excel(data):
# 创建excel工作表
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('skiing')
# 写表头
for index, val in enumerate(data<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [python json数据写入excel](https://blog.csdn.net/qq_28949847/article/details/130251230)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
- *2* *3* [Python读取json文件,并将其写入excel](https://blog.csdn.net/MilkLeong/article/details/115832755)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
[ .reference_list ]