```python
# !/bin/python3
# -*- coding: utf-8 -*-
import mydata
#自定义mydata.py文件
import xlwt
data=mydata.data['data']
#将数据放到mydata.py文件中,可以避免代码行过长
excel = xlwt.Workbook()
sheet1 = excel.add_sheet('sheet1', cell_overwrite_ok=True)
#打开excel文件
length = len(data)
#列表的总长度
i = 0
while i < length:
eachLine = data[i]
#取列表的每一个子列表的
keys= list(eachLine.keys())
#取得列表的每个key名称,作为表头项和取值依据
j=0
if i==0:
for j in range(len(keys)):
sheet1.write(i, j, str(keys[j]))
#表头项
sheet1.write(i+1, j, eachLine[str(keys[j])])
#第一个列表的值
else:
for j in range(len(keys)):
sheet1.write(i+1, j, eachLine[str(keys[j])])
#取值
i = i + 1
#循环,处理下一个列表的内容
excel.save('D:/answer.xls')
#保存到文件中
数据:
data={"code":"0","msg":" ","data":[{"id":"8fc2bf5","priority":"高","update_timestamp":1584713237000},{"id":"8fc01f5","priority":"高","update_timestamp":1584713237000}]}