Reading test data from Excel in Selenium Python - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of this Excel data reading code?

Given the following Python code snippet using openpyxl to read an Excel file, what will be printed?

Selenium Python

from openpyxl import load_workbook
wb = load_workbook('testdata.xlsx')
sheet = wb.active
value = sheet['B2'].value
print(value)

A Raises KeyError

B None

C Raises FileNotFoundError

D The value in cell B2 of the Excel sheet

💡 Hint

Check if the file exists and the cell B2 has data.

The code loads the Excel file and reads the value in cell B2. If the file exists and B2 has data, it prints that data.

❓ assertion

intermediate

Which assertion correctly verifies the Excel cell value?

You read a value from Excel cell A1 into variable 'cell_value'. Which assertion correctly checks it equals 'TestUser'?

Selenium Python

cell_value = sheet['A1'].value

A assert cell_value is 'TestUser'

B assert cell_value = 'TestUser'

C assert cell_value == 'TestUser'

D assert cell_value != 'TestUser'

💡 Hint

Use double equals for comparison in assertions.

Option C uses the correct equality operator '==' to compare values. Option C uses assignment which is invalid syntax. Option C asserts inequality which is wrong. Option C uses 'is' which checks identity, not equality.

❓ locator

advanced

Choose the best locator to find a cell value in Selenium after reading from Excel

You read a username from Excel and want to find the input box on a web page to enter it. Which locator is best practice?

A driver.find_element(By.CSS_SELECTOR, 'input[type=text]')

B driver.find_element(By.ID, 'username')

C driver.find_element(By.XPATH, '//input[@name="user"]')

D driver.find_element(By.TAG_NAME, 'input')

💡 Hint

Use unique and stable locators.

ID locators are unique and fast. XPath and CSS selectors can work but may be less stable or slower. Tag name alone is too generic.

🔧 Debug

advanced

Identify the error in this Excel reading code snippet

What error will this code raise?

Selenium Python

from openpyxl import load_workbook
wb = load_workbook('data.xlsx')
value = wb['Sheet1']['A1']
print(value.value)

A No error, prints the cell value

B TypeError: 'Workbook' object is not subscriptable

C KeyError: 'Sheet1'

D AttributeError: 'Cell' object has no attribute 'value'

💡 Hint

Check how to access sheets in openpyxl.

No error is raised. Workbook objects are subscriptable by sheet name (wb['Sheet1'] returns the worksheet), worksheets are subscriptable by cell address (['A1'] returns the Cell), and cell.value gets the data.

❓ framework

expert

Which test framework feature best supports reading Excel data for multiple test cases?

You want to run a Selenium test multiple times with different data from Excel. Which pytest feature helps best?

A @pytest.mark.parametrize decorator with data loaded from Excel

B Using unittest.TestCase with setUp method reading Excel once

C Using pytest fixtures to read Excel data once per session

D Hardcoding data inside the test function

💡 Hint

Think about running tests multiple times with different inputs.

Parametrize decorator allows running the same test with different inputs easily. Fixtures can help but parametrize is designed for multiple data sets. Hardcoding is not flexible. unittest setUp runs before each test but does not parametrize.

Practice

1. What is the main reason to read test data from an Excel file in Selenium Python tests?

easy

A. To create Excel files automatically

B. To make the test code run faster

C. To run tests with many different inputs easily

D. To avoid writing any test code

Solution

1. Step 1: Understand test data usage

   Test data from Excel allows running the same test with many inputs without changing code.

2. Step 2: Identify the benefit

   This makes tests flexible and easier to maintain.

3. Final Answer:

   To run tests with many different inputs easily -> Option C

4. Quick Check:

   Reading Excel data = flexible inputs [OK]

Hint: Excel stores many inputs for tests in one place [OK]

Common Mistakes:

• Thinking Excel makes tests faster
• Believing Excel replaces test code
• Confusing data reading with file creation

2. Which Python library is commonly used to read Excel files for Selenium tests?

easy

A. selenium

B. pandas

C. requests

D. openpyxl

Solution

1. Step 1: Recall Excel reading libraries

   openpyxl is a popular library to read/write Excel files in Python.

2. Step 2: Differentiate from other libraries

   pandas can read Excel but is heavier; requests is for web calls; selenium is for browser automation.

3. Final Answer:

   openpyxl -> Option D

4. Quick Check:

   Excel reading = openpyxl [OK]

Hint: openpyxl is made for Excel files in Python [OK]

Common Mistakes:

• Choosing selenium which automates browsers
• Picking requests which handles HTTP
• Confusing pandas with openpyxl

3. Given this code snippet, what will be printed?

from openpyxl import load_workbook
wb = load_workbook('data.xlsx')
sheet = wb.active
print(sheet['A2'].value)

Assuming cell A2 contains the text "TestUser".

medium

A. data.xlsx

B. TestUser

C. sheet['A2']

D. None

Solution

1. Step 1: Understand openpyxl cell access

   sheet['A2'].value reads the content of cell A2 in the active sheet.

2. Step 2: Check given cell content

   Cell A2 contains "TestUser", so print outputs this string.

3. Final Answer:

   TestUser -> Option B

4. Quick Check:

   sheet['A2'].value = "TestUser" [OK]

Hint: sheet['A2'].value reads cell A2 content [OK]

Common Mistakes:

• Printing the cell object instead of its value
• Confusing filename with cell content
• Expecting None if cell has text

4. What is wrong with this code snippet for reading Excel data?

from openpyxl import load_workbook
wb = load_workbook('testdata.xlsx')
sheet = wb['Sheet1']
for row in sheet.iter_rows(min_row=2, values_only=True):
    print(row[0])

medium

A. No error; code reads first column from second row correctly

B. Using sheet['Sheet1'] instead of wb['Sheet1']

C. Not specifying min_row=1 in iter_rows

D. Missing call to wb.save() before reading

Solution

1. Step 1: Check sheet access

   wb['Sheet1'] correctly accesses the sheet named 'Sheet1'.

2. Step 2: Analyze iter_rows usage

   iter_rows with min_row=2 and values_only=True returns tuples of cell values from second row onward.

3. Step 3: Confirm print statement

   Printing row[0] prints the first column value of each row starting from row 2.

4. Final Answer:

   No error; code reads first column from second row correctly -> Option A

5. Quick Check:

   Code reads data correctly [OK]

Hint: wb['Sheet1'] accesses sheet; iter_rows returns values [OK]

Common Mistakes:

• Using sheet['Sheet1'] instead of wb['Sheet1']
• Forgetting values_only=True to get cell values
• Thinking wb.save() is needed before reading

5. You want to read username and password pairs from Excel to run login tests. Which approach is best to handle empty cells safely?

hard

A. Use iter_rows with values_only=True and check if each cell is None before using

B. Skip checking cells and assume all data is present

C. Use sheet['A1'].value only and ignore other rows

D. Convert Excel file to CSV and read with open()

Solution

1. Step 1: Understand data safety

   Empty cells in Excel return None, which can cause errors if not checked.

2. Step 2: Use iter_rows with values_only=True and check for None

   This approach reads all rows and allows safe validation before using data in tests.

3. Step 3: Avoid unsafe assumptions

   Skipping checks or reading only one cell risks test failures or incomplete coverage.

4. Final Answer:

   Use iter_rows with values_only=True and check if each cell is None before using -> Option A

5. Quick Check:

   Check None in cells to avoid errors [OK]

Hint: Always check for None in Excel cell values [OK]

Common Mistakes:

• Ignoring empty cells causing test crashes
• Reading only one cell missing data
• Converting to CSV losing Excel features