import base64
import json
import time
import requests
import selenium
service = Service(executable_path=r'D:\ide\anaconda\chromedriver.exe')
browser = webdriver.Chrome(service=service)
data = load_workbook('1.xlsx')
sheetnames = data.get_sheet_names()
sheet = data.get_sheet_by_name(sheetnames[0])
sheet = data.active
nrows = sheet.max_row
list1 = ['A','B','C','D','E','F','G','H','J','K','L','M','N','O','P','Q','R','S','T','W','X','Y','Z']
browser.get('http://www.iplant.cn/frps/cname/'+str(j)+'')
a = browser.find_element(By.XPATH,'//*[@id="voldiv"]/div[3]/table/tbody/tr[2]/td[2]/div['+str(i)+']/a').get_attribute("href")
b = a[26:]
c = b[:-4]
d = c.replace('%20','+')
e = c.replace('%20',' ')
url = 'http://www.iplant.cn/ashx/getfrps.ashx?key='+str(d)
url1 = 'http://www.iplant.cn/ashx/getcol.ashx?name='+str(e1,'utf-8')
headers = {'content-type': 'application/json', 'Api-Token': '4c67f2c4e0b72a5fd1aac6a461c5c1b0'}
r = requests.get(url, verify=False, headers=headers)
sheet.cell(nrows + 1, 1).value = "name"
sheet.cell(nrows + 1, 2).value = "posi"
sheet.cell(nrows + 1, 3).value = "result"
sheet.cell(nrows + 1, 4).value = "jie"
sheet.cell(nrows + 1, 5).value = "men"
sheet.cell(nrows + 1, 6).value = "gang"
sheet.cell(nrows + 1, 7).value = "mu"
sheet.cell(nrows + 1, 8).value = "ke"
sheet.cell(nrows + 1, 9).value = "shu"

data.save('3s.xlsx')
data.close()
print("Excel 文件已创建并数据已追加成功！")