json字典数据转化存写excel

## coding:utf-8
import json
import xlwt
a = """[{"name"：”李“,"编号":1992,"年龄"："11"，"性别":"男","班级":"初一二班"}]"""
#新建生成表格
import json,xlwt
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('sheet1')

# 设置表头
worksheet.write(0, 0, label='名字')
worksheet.write(0, 1, label='编号')
worksheet.write(0, 2, label='年龄')
worksheet.write(0, 3, label='性别')
worksheet.write(0, 4, label='班级')




# # 读取json文件
with open('banner.json', 'r') as f:
 data = json.load(f)

#全局递增变量
num0 = 1
num1 = 1
num2 = 1
num3 = 1
num4 = 1
def for_ever():
# data = json.loads(a)
	for list_item in data:
		for key, value in list_item.items():
  			if key == "name":
   				worksheet.write(val0, 0, value)
   				val1 += 1
  			elif key == "dev":
   				worksheet.write(val1, 1, value)
   				val2 += 1
  			elif key == "age":
  				 worksheet.write(val2, 2, value)
   				val3 += 1
 			elif key == "sex":
   				worksheet.write(val3, 3, value)
   				val4 += 1
  			elif key == "class":
   				worksheet.write(val4, 4, value)
   				val5 += 1
  			else:
   				pass
			#保存
			workbook.save('sum.xlsx')