python网页填单，excel获取数据，selenium

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 &#