-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdata_driven_excel.py
More file actions
21 lines (21 loc) · 899 Bytes
/
Copy pathdata_driven_excel.py
File metadata and controls
21 lines (21 loc) · 899 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
from selenium import webdriver
import pyxl
path='E:/data.xlsx'
driver=webdriver.Chrome(executable_path='chromedriver.exe')
driver.maximize_window()
driver.get('http://newtours.demoaut.com/')
row=pyxl.row_count(path,'Sheet1')
for r in range(2,row+1):
user_name=pyxl.read_data(path,'Sheet1',r,1)
print(user_name)
password=pyxl.read_data(path,'Sheet1',r,2)
print(password)
driver.find_element_by_name('userName').send_keys(user_name)
driver.find_element_by_name('password').send_keys(password)
driver.find_element_by_name('login').click()
if driver.title=='Find a Flight: Mercury Tours:':
pyxl.write_data(path, 'Sheet1', r,3,'Passed')
else:
pyxl.write_data(path, 'Sheet1', r, 3, 'Failed')
driver.find_element_by_xpath('/html/body/div/table/tbody/tr/td[1]/table/tbody/tr/td/table/tbody/tr/td/table/tbody/tr[1]/td[2]/font/a').click()
driver.quit()