获取github的接口地址写入excel
获取github的接口地址
1 from xlwt import * 2 import requests 3 import json 4 5 file = Workbook(encoding='utf-8') 6 table = file.add_sheet('url') 7 style = easyxf('align: vertical center, horizontal center') 8 9 r = requests.get('https://api.github.com/', verify=False) 10 row0 = ['序号', '接口名称', '接口地址'] 11 for j in range(len(row0)): 12 table.write(0, j, row0[j], style) 13 14 data = json.loads(r.text) 15 i = 1 16 for k,v in data.items(): 17 table.write(i, 0, i, style) 18 table.write(i, 1, k) 19 table.write(i, 2, v) 20 i = i + 1 21 22 file.save("F://python_interface_test/python_interface_test/aa.xls")