Selenium with Python Tutorial 26-Data Driven Testing using Microsoft Excel + OpenPyXL Module

Topic : Data Driven Testing using Microsoft Excel + OpenPyXL Module

#########################
Udemy Courses:
#########################

Manual Testing+Agile with Jira Tool
************************************

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
****

linux & Shell Scripting
**********************

Java
*****

Selenium With Java+Cucumber
********************************

Python
***************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#Selenium
#Python
#DataDrivenTesting
#AutomationTesting
#TestAutomation
#QualityAssurance
#SoftwareTesting
#TestScripts
#TestAutomationFramework
#WebTesting
#UIAutomation
#TestCases
#TestingTools
#SeleniumWebDriver
#TestAutomationTools
#TestAutomationEngineer
#DataDrivenFramework
#TestScripting
#TestAutomationScript
#TestAutomationDevelopment
#TestAutomationLifeCycle
#TestAutomationBestPractices
#DataTesting
#PythonSelenium
#SeleniumTesting
#AutomatedTesting
#TestDesign
#TestScenarios
#TestExecution
#CrossBrowserTesting
#ContinuousIntegration
#AutomationStrategy
#CodeQuality
#RegressionTesting
#DataValidation
#DataIntegration
#DataAnalysis
#DataVisualization
#PythonProgramming
#TestDataManagement
#TestAutomationChallenges
#TestingFrameworks
#TestAutomationTips
#SeleniumTips
#SoftwareDevelopment
#AgileTesting
#CI/CD
#AutomatedTestScripts
#TestingCommunity
#QualityEngineering

[nelsonpaulista]

Hello from Brazil. Thanks for the video. Your Python Selenium tutorials are the best. Thank you very much.

[vijaymgra]

Thanks.... that's what I was looking for

[vijaylink]

Really nice. Thank you Pavan-ji, learned something new today. Though. there should be logout action in case of Passed'.

[neelambikalearnfun]

Thank you. Am learning python now a days. And your tutorial is really helpful...

[padman]

Thanks for the vedio, Could you provide any vedio related to defect tracking tool for python selenium webdriver

[farihahossain]

How to write a code? if there is any row or column that is empty.if it happens on execution time and finds an empty row middle of an execution .

[manigandanrajagopal]

Is it possible to use selenium python secured web page. our testing site have security popup before launching the web page. after launch we can use as guest or login with userid.

[vaibhavdatir]

Suppose i have to pass null value from excel, ex user name is blank and password field has some value. How to read this scenario.
It give type error which i handle but then it throw out of loop and password value not read.
Kindly help

[zozonoaroro]

Is it possible to link an excel file with a cucumber scenario outline in pytest bdd framework

[neelambikalearnfun]

Hello sir. Do u have data driven example using pandas

[praveenshet]

Sir how read numerical values from excel sheet

[sourabhshalini]

How to remove hard coding for column, please provide some information

[MegaBhari]

above code[video} is used in pytest for the testscript throwing error .
Hi,

Scenario : I am trying get username and password from excel sheet then trying to pass to the function " test_validate_login()"
exceltestscript.py


import pytest
import unittest
import openpyxl
import xlrd
from pages.LoginPO import LoginPO
from Datagenerator import datagen

@pytest.mark.usefixtures("setup", "onetime_setup")
class


def setup(self):
print("setup")
self.lp = LoginPO(self.driver)


@pytest.mark.parametrize('data', datagen.datagenerator())

def test_validate_login(self, data):

LoginPO.sendusername(data)
LoginPO.sendpwd(data)
terminal : Error is displayed

" TypeError: test_validate_login() missing 1 required positional argument: 'data' "

Request you all share the solution .

[manorathvaja]

I have used the same XLUtils as mentioned in this video but getting error:
TypeError: get_sheet_names() takes 1 positional argument but 2 were given

[alpeshsiyani]

Login in capche how to show vision command

[richagupta]

Suppose if we have a radio button in a web page whose value needs to be selected on the basis of value given in excel sheet..in that case how we will do that??

[suhasrkaveri]

Sir, is there any way in Java or Python to read write data line by line inside text file like as you did in excel file. Please anybody reply.

[aasthasharma]

get_sheet_by_name is not a valid function defined by workbook
please suggest

[mrunalnandurkar]

I am unable to install openpyxl from available packages. getting connection issue.

[swatimishra]

Sir I request to you please increase your front size for code.