####读取excel
import pandas as pd
import numpy as np
import re
#keep_default_na空字符读取出来就不是nan了,header=None第一行也读取 不作为表头
df = pd.read_excel('食物成分表完整版.xlsx',keep_default_na=False)
#.values将DataFrame转为numpy .tolist() 将numpy转为list
data=[re.sub("['(',')',' ']",'',x) for x in set(df.values[:,0].tolist())]
####添加种类
from selenium import webdriver
import time
from selenium.webdriver.common.keys import Keys
driver=webdriver.Chrome()
driver.get(url='https://www.amaoee.cn/TyQEOGLsfv.php/index/login')
#是窗口最大化
driver.maximize_window()
driver.implicitly_wait(10)
#账号
driver.find_element_by_xpath('//*[@id="pd-form-username"]').send_keys('')
time.sleep(0.2)
#密码
driver.find_element_by_xpath('//*[@id="pd-form-password"]').send_keys('')
driver.find_element_by_xpath('//*[@id="login-form"]/div[5]/button').click()
driver.implicitly_wait(10)
driver.find_element_by_xpath('//*[@id="tabs"]/div/aside[1]/div/section/ul/li[8]/a').click()
for index,value in enumerate(data):
driver.find_element_by_xpath('//*[@id="tabs"]/div/aside[1]/div/section/ul/li[8]/ul/li[1]/a').click()
driver.implicitly_wait(10)
time.sleep(0.2)
#先定位到iframe
elementi= driver.find_element_by_xpath('//*[@id="con_129"]/iframe')
#再将定位对象传给switch_to_frame()方法
driver.switch_to_frame(elementi)
time.sleep(1)
###添加按钮
driver.find_element_by_xpath('//*[@id="toolbar"]/a[2]').click()
time.sleep(0.2)
#先定位到iframe
xpath='//*[@id="layui-layer-iframe{}"]'.format(index+1)
elementi2= driver.find_element_by_xpath(xpath)
#再将定位对象传给switch_to_frame()方法
driver.switch_to_frame(elementi2)
time.sleep(0.2)
###键盘回车
driver.find_element_by_xpath('//*[@id="c-name"]').send_keys(value)
time.sleep(0.5)
query=driver.find_element_by_xpath('//*[@id="c-name"]')
query.send_keys(Keys.ENTER)
time.sleep(1)
###退出iframe
driver.switch_to_default_content()
driver.close()
读取单页excel、selenium切换iframe、键盘回车
最新推荐文章于 2024-09-19 18:04:15 发布