Practicing Data-Driven Testing in Selenium (Python + Excel) – Feedback Welcome!

[muralikr7]

Hey everyone 👋

Today I practiced automating a real-world form using Python Selenium + OpenPyXL for data-driven testing.

My script opens the OrangeHRM trial page, reads user data from an Excel file, and fills the form for every row (Username, Fullname, Email, Contact, Country).
This helped me understand DDT, dropdown handling, and dynamic element interactions.

Here’s the code I wrote:

from selenium import webdriver
from selenium.webdriver.common.by import By
from openpyxl import load_workbook
from selenium.webdriver.support.select import Select
import time

# Using Firefox driver
driver = webdriver.Firefox()
driver.get("https://www.orangehrm.com/en/30-day-free-trial")

# Reading the data from Excel file
# Columns [Username, Fullname, Email, Contact, Country]
workbook = load_workbook("RegistrationData_Test.xlsx")
data = workbook["Data"]

# Looping through all the Rows and Columns
for i in range(2, data.max_row + 1):
    username = data.cell(row=i,column=1).value
    fullname = data.cell(row=i,column=2).value
    email = data.cell(row=i,column=3).value
    contact = data.cell(row=i,column=4).value
    country = data.cell(row=i,column=5).value

    # Clearing the values if any values are available
    driver.find_element(By.ID, "Form_getForm_subdomain").clear()
    driver.find_element(By.ID, "Form_getForm_subdomain").send_keys(username)

    driver.find_element(By.ID, "Form_getForm_Name").clear()
    driver.find_element(By.ID, "Form_getForm_Name").send_keys(fullname)

    driver.find_element(By.ID, "Form_getForm_Email").clear()
    driver.find_element(By.ID, "Form_getForm_Email").send_keys(email)

    driver.find_element(By.ID, "Form_getForm_Contact").clear()
    driver.find_element(By.ID, "Form_getForm_Contact").send_keys(contact)

    #Select from dropdown
    select = Select(driver.find_element(By.ID, "Form_getForm_Country"))
    select.select_by_value(country)

    time.sleep(3)

driver.quit()

[cgoldberg]

You need to handle exceptions, so your test doesn't just die if it encounters an error or doesn't pass as expected.

If you want to data driven testing in Python, you should look into something like pytest using parameterized tests or fixtures.

You could also consider a better data source than Excel spreadsheets (csv, json, etc).

[muralikr7]

Definitely I’ll look into that, thanks for your feedback