调用获取学生信息的接口，保存到excel里面的小程序

# 2、http: // doc.nnzhp.cn / index.php?s = / 6 & page_id = 14
# 调用获取学生信息的接口，保存到excel里面

import requests,xlwt

def get_stu_info():
    url='http://api.xxx.cn/api/user/xxx_xxx'
    header={'Referer':'http://api.xxx.cn/'}
    res=requests.get(url,headers=header).json()
    return res.get('stu_info')
# res=get_stu_info()
# print(res)


def write_to_excel():
    all_stu=get_stu_info()
    book = xlwt.Workbook()  # 新建一个excel
    sheet = book.add_sheet('学生信息')  # 加sheet页
    title=all_stu[0].keys()
    for col, t in enumerate(title):  #写表头
        sheet.write(0, col, t)
    row = 1
    for stu in all_stu:
        for col, v in enumerate(stu.values()):
            sheet.write(row, col, v)
        row += 1  # 每次写完一行，行就加1
    book.save('stu_info.xls')
write_to_excel()