获取github的接口地址写入excel

获取github的接口地址

from xlwt import *
import requests
import json

file = Workbook(encoding='utf-8')
table = file.add_sheet('url')
style = easyxf('align: vertical center, horizontal center')

r = requests.get('https://api.github.com/', verify=False)
row0 = ['序号', '接口名称', '接口地址']
for j in range(len(row0)):
    table.write(0, j, row0[j], style)

data = json.loads(r.text)
i = 1
for k,v in data.items():
    table.write(i, 0, i, style)
    table.write(i, 1, k)
    table.write(i, 2, v)
    i = i + 1

file.save("F://python_interface_test/python_interface_test/aa.xls")