Selenium with Python Tutorial 25-How to write data into Excel using OpenPyXL | Data Driven Testing

Topics :
----------
1. How to write data into 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]

Thanks a lot sir, u helped me a lot to understand the concepts ...

[rajkumargerard]

Hello Sir first of all thanks very much for your efforts to teach us these skills... Much appreciated... Required your help in automating date pickers in web... where in need to input a date by selecting from calendar... Could you help me....?

[kaushikswaminathan]

I want help on how to write data into excel from a list..
Also plse can you help how to write data into multiple sheets on single workbook

[sonardhananjay]

import openpyxl
import random

path =

workbook = openpyxl.load_workbook(path)

sheet = workbook.active



for r in range(1, 5):
for c in range (1, 4):

sheet.cell(row=r, column=c).value= random.randrange(11, 91, 3)
workbook.save(path)

[mithileshpandit]

Hi, Can you please let me know if we can use a link of s3 bucket in place of ?

[dabrosz]

Is this supposed to work on excel 2010, mine doesn't work