获取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")

 

posted @ 2018-04-07 23:08  打不过小怪兽leer  阅读(143)  评论(0)    收藏  举报