Part 19- Data Driven Testing Using Excel & CSV Files in Robot Framework | Selenium with Python

Topics: Data Driven Testing Using Excel & CSV Files in Robot Framework

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

#DataDrivenTesting
#RobotFramework
#TestAutomation
#ExcelFiles
#CSVFiles
#AutomationTesting
#TestScripts
#QA
#QualityAssurance
#TestAutomationFramework
#TestData
#AutomationEngineer
#SoftwareTesting
#TestCases
#AutomationFramework
#TestingTools
#TestDataManagement
#ExcelAutomation
#CSVAutomation
#Selenium
#DataFiles
#TestExecution
#Scripting
#TestScenarios
#TestManagement
#AutomationBestPractices
#TestCaseDesign
#DataValidation
#AutomationScripts
#CodeQuality
#QualityEngineering
#EfficientTesting
#DataDrivenApproach
#AutomationStrategy
#TestDevelopment
#TestFrameworks
#ExcelTesting
#CSVTesting
#ContinuousTesting
#ScriptedTesting
#TestDesign
#TestArchitecture
#DataAutomation
#TestAutomationLifecycle
#RoboticTesting
#DataIntegration
#TestManagementTools
#AutomationChallenges
#RegressionTesting
#AgileTesting

[koushikkndl]

Thanks for your videos on ROBOT FRAMEWORK, i reallyAppreciate your work, keep up the same.

[someshugar]

Thank you
Very useful I was looking for this from some many days

[automationra]

this is interesting!!! I hope you have a tutorial on how to web scraping using robot framework.

[peace]

How do place the excel file in python? Like how to put that logindata file under Testdata? Please Reply

[panuwatm.]

Where did you get the TestData file from please help me

[pallabisaha]

Hello Sir your tutorial is really helpful. Can you please upload a video about windows application automation using the Robot framework in Pycharm

[ainomar]

Hi Pavan, do u probably know, if is it possible the DataDriver Library in Robot Framework to have more than 1 sheet_names?. I have 1 xlsx file, but i separate the input for different screen into 2 sheets within the same excel file. Do u have any idea how to retrieved data from 2 different sheet within 1 excel file? Or can use other Library?
Thanks in advance.

[merceditaespedillon]

This is quite impressive. And I have a question though, how can you run this having a test case -t as a parameter?

[raghuramkk]

Thanks Pavan. Lots of useful information.
Can we use the data in different worksheets in the same excel within the same test case / script

[Puresoul]

Thanks a lot for the video. Very useful.. I have a question. If we have multiple test cases in single robot file, how can we call the test data with respect to each test case from excel or csv?

[vinayrana]

How can we save dropdown element data into CSV/excel and call it in our testcase?

[sureshbabu-ldkg]

Hi,
how to read the excel file using single robotfile itself, here u used loginresouce.robot as a login and DDT2 file used to call the loginresouce using RESOURCE key word instead of that how to used in single robot file itself

[khairulamir]

Hi Sir,

after using datadriver, do we able to use tagging as well?
filtering test case with tag

thanks

[Himu]

Hello guys I’m implementing a data driven framework using excel file but I’m gettin error ‘variable ${username} not found. I did add data driver package and ran pip install robotframework-excellib . I did proper spacing. Can one someone please help ? Spending whole day but still couldn’t make this work

[MalegaonDiary]

Now it ask pip install -U

it will install pandas and opeyxl
then Excel will support

[kishorenaidu]

Hi sir, could you please explain how to run testes with different keyword using data driven with excel

[rsudarsan]

hi Sir, is it possible to make one video to call the keywords and test data from excel and update the results(Pass/Fail) the same in Excel as part of the DDT Testing in Robot Framework.

[devdaschatterjee]

import this with 'pip install -U if you are getting import error

[kishormahajan]

Can we run the specific data from Excel?
Means I have multiple rows in Excel each row represent as different test case and I have similar column names in Excel so how can we differenciate the rows??

[AK-exmd]

Pls tell me Where can we find the scripts?