import openpyxl
from selenium import webdriver
#configure workbook path
b = openpyxl.load_workbook("F:\\Data1.xlsx")
#get active sheet
sht = b.active
#get cell address of email within active sheet
e = sht.cell (row = 2, column = 1)
#get cell address of password within active sheet
p = sht.cell (row = 2, column = 2)
#get values
email = e.value
passw = p.value
#set chromodriver.exe path
driver = webdriver.Chrome(executable_path="F:\\Work Environment\\MyProject\\chromedriver.exe")
driver.implicitly_wait(0.5)
#launch URL
driver.get("https://www.facebook.com/")
#identify element
l = driver.find_element_by_id("email")
#enter email obtained from excel
l.send_keys(email)
l.screenshot("screenshot_text.png")
m = driver.find_element_by_id("pass")
#enter password obtained from excel
m.send_keys(passw)
m.screenshot("screenshot_text2.png")
#get values entered
s = l.get_attribute("value")
t = m.get_attribute("value")
print("Email is: ")
print(s)
print("Password is: ")
print(t)
#browser quit
driver.quit()