import requests
import json
from requests.packages import urllib3
from nacl.pwhash import verify
import xlrd
from xpinyin import Pinyin
from idlelib.iomenu import encoding
p = Pinyin()
urllib3.disable_warnings() #disable ssl warning
导入excel数据 ——begin———-
config_file = input(“请输入需要导入的excel表格名称,请带后缀如:配置信息.xlsx,配置文件请放在python脚本一个文件夹下:”)
data = xlrd.open_workbook(config_file,’r’)
table = data.sheets()[0]
nrows = table.nrows
ncols = table.ncols
导入excel数据 ——–end———–
create auth token
f5_ip = input(“请输入F5管理IP:”)
username = input(“请输入F5管理账户:”)
password = input(“请输入F5管理密码:”)
req_url = ‘https://%s/mgmt/shared/authn/login’ %(f5_ip)
data = {‘usernam