I am a beginner in the world of automation and I'm currently working on automating a website that contains various links. Initially, I hardcoded the user name and password, and was able to select the link using Link_text successfully. However, when I attempted to retrieve the data from an Excel file for the credentials, the username and password fields were populated but I encountered an issue with selecting the link. Can anyone offer assistance with this problem?
Here is the code snippet:
import XLutils
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
driver = webdriver.Chrome(r'C:\Users\test\AppData\Local\Programs\chromedriver_win32\chromedriver.exe')
driver.get("https://test.com")
driver.maximize_window()
path = r'C:\Users\test\Desktop\Reports Test.xlsx'
rows = XLutils.getRowCount(path, 'Login')
username = XLutils.readData(path, "Login", 2, 1)
password = XLutils.readData(path, "Login", 2, 2)
driver.find_element(By.ID, 'username').clear()
driver.find_element(By.ID, 'username').send_keys(username)
driver.find_element(By.ID, 'password').clear()
driver.find_element(By.ID, 'password').send_keys(password)
driver.find_element(By.XPATH, '/html/body/app-root/body/div/app-login/div\[2\]/div\[2\]/form/div\[4\]/button').click()
driver.find_element(By.LINK_TEXT, 'Offer Activity').click()
HTML:
<a class="reportLink" href="null"> Offer Activity </a>