获取token值并写入Excel文件中

#导入库包
import os.path
import requests
import responses
import json
import xlsxwriter

#定义函数
def get_token():
url = 'http://XXXXXX:8060/api/gv-op/userAuth/login'
header = {
"Accept": "application/json, text/plain, */*",
"Content-Type": "application/json",
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.82 Safari/537.36"
}
data = {"account": "username","password": "passwd"}
res = requests.post(url=url, headers=header, data=json.dumps(data))
tt = json.loads(res.text)
refreshToken = tt["data"]["refreshToken"]
accessToken = tt["data"]["accessToken"]
return refreshToken,accessToken