helium操作弹窗以及处理excel

    chrome_options = webdriver.ChromeOptions()
    chrome_options.add_argument('log-level=3')
    prefs = {"download.default_directory": 'C:\\Users\\Core\\Desktop\\项目整理20181225\\cjtjNew20200228',
           }
    chrome_options.add_experimental_option("prefs", prefs)
    driver1 = webdriver.Chrome(chrome_options=chrome_options)
    driver1.maximize_window()
    driver1.get('https://sycm.taobao.com/custom/login.htm?_target=http://sycm.taobao.com/')
    driver1.delete_all_cookies()
    for cookie in _sycm_headers["Cookie"].split("; "):
        cookie = cookie.split("=")
        driver1.add_cookie({
            'domain': '.taobao.com',
            'name': cookie[0],
            'value': cookie[1],
            'path': '/',
        })
    _url_cjtjCY2 = 'https://tuijian.taobao.com/indexbp.html#!/report/index?alias=def&bizCode='
    url_cjtjXH2 = _url_cjtjCY2.format(yes_date=day)
    driver1.get(url_cjtjXH2)
    time.sleep(5)
    set_driver(driver1)
    scroll_down(num_pixels=500)
    time.sleep(2)
    click("下载报表")
    write("expython",into="名称")
    time.sleep(2)
    click("确定")
    time.sleep(10)
    try:
        kill_browser()
    except:
        pass

处理excel

    new_xls_name = [name for name in os.listdir('.') if name.startswith("expython")][0]
    df = pd.read_excel(new_xls_name)
    cc = df.fillna(0)
    all_row = cc.shape[0]
    data_name = ['计划','主体名称', '创意名称','创意ID','消耗', '展现量', '点击量', '点击率', '收藏宝贝量','添加购物车量','成交订单量','成交订单金额']
    trans_data = cc[data_name]
    a = [list(trans_data.ix[i].values) + [erpId, day] for i in range(0, all_row)]
    b = "%s" % (a)
    all_lx = eval(b)
    os.remove(new_xls_name)