python网页填单,excel获取数据,selenium
给别人写的脚本,只是已经用不上了
from selenium import webdriver
import time
import xlrd
from datetime import date,datetime
from selenium.webdriver.chrome.options import Options
def main():
wd = webdriver.Chrome()
wd.implicitly_wait(10)
wd.get('https://consoleprod.csgmall.com.cn/o2om/consignment-query-supplier/list')
wd.set_window_position(20, 40)
wd.set_window_size(1100, 700)
elementuser = wd.find_element_by_id('username')
elementuser.send_keys('用户名')
elementpass = wd.find_element_by_id('password')
elementpass.send_keys('密码')
elementbutton = wd.find_element_by_tag_name('button')
elementbutton.click()
time.sleep(1)
enter = wd.find_element_by_class_name('ant-modal-close-x')
enter.click()
time.sleep(6)
elementinput = wd.find_elements_by_class_name('ant-input')[0]
xl = xlrd.open_workbook('1.xlsx') #excel
table = xl.sheets()[0]
rows &#