Python Forum

Full Version: multi login from excel list
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I would like to access a site with 10 accounts. I would like to avoid creating 10 .py files. How can I solve this problem?
import time
import os
import zipfile
from random import randint
from numpy.random import randint
import xlrd
workbook = xlrd.open_workbook("C:/Users/utente/Desktop/Selenium code/list.xlsx")
worksheet = workbook.sheet_by_name("LIST")

url = str(worksheet.cell(1,9).value) #

driver.get(url)
driver.implicitly_wait(200)

username = str(worksheet.cell(1,6).value)
password = str(worksheet.cell(1,7).value)

time.sleep(3)
driver.find_element_by_id('login-button').click()
access the first site (do not close the page)
open the second Chrome login site (do not close) etc ...

How can I solve this problem?