接收数据类型json:
list_dict=[{“user”:“hy”,“score”:97},{“user”:“fl”,“score”:65}]
def jsonToexcel():
jsonfile = list_dict
print (jsonfile)
workbook = xlwt.Workbook()
sheet1 = workbook.add_sheet('Sheet1')
ll = list(jsonfile[0].keys())
for i in range(0,len(ll)):
sheet1.write(0,i,ll[i])
for j in range(0,len(jsonfile)):
m = 0
ls = list(jsonfile[j].values())
for k in ls:
sheet1.write(j+1,m,k)
m += 1
workbook.save('student.xls')