Selenium with Python Tutorial 24-How to read data from MS-Excel using OpenPyXL | Data Driven Testing

Topics :
----------
1. How to read data from MS-Excel using OpenPyXL
2. Data Driven Testing

#########################
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

[rameshyampalla]

Thank you sir for your explnation in a easy owe u

[nishadshivprakash]

That's the video, which i was searching.. Thank you...

How can I copy or extract the data to text file. From any perticular range

[shaiksubhan]

Thanks, , , , this video is very helpful for me, very good

[sameerk]

Thank you very much for this helpful and easy to understand tutorial....appreciated.

[vishnuvishu]

Thank you so much Sir for this helpful tutorial. I have written the code as mention by you and able to print "Max_Rows and Max_Col" but unable to print the cell data and getting an error "TypeError: cell() got an unexpected keyword argument 'rows'. Kindly suggest to resolve the issue. Thank you very much for your kind help.

[jjactual]

is there a way to print the rows from column 1 only? and print rows from second column separately? please help

[mithileshpatil]

how to get the data for particular value. for eg i want to access the value lets say Empid '112', know his salary. i basically want find a particular value in excel

[nomaniub]

Hi, I have a test to download an excel file. After downloading, I am using os.startfile to open the excel workbook. But once it is open, I am not able to close it. Can you help me with any solution ? Need help !!!

[codebnder]

sheet = workbook["<name of sheet>"] for specific sheet

[chundurusriharsha]

How can I compare between the two CSV(xlxs) files? Can I know how?

[slayerofundead]

How I can save values of fixed columns into a list?

[pandudamera]

If I have multiple sheets, how will I use ? Please let me know sir

[abhiramgannavaram]

How to save the result/output value in excel
For ex if l given some testing details after that result will come I need to save the result in the excel

[shalinaparveen]

By using "sheet.max_row
", "sheet.max_column" you got 13, 4 in your output(you got only filled cells instead of blank ones in output) but I'm getting total no of cells i.e., 1001, 29 (including blank ones). i want only filled cells. how?