Рет қаралды 69,116
automationstep...
Katalon Studio
How to get data from excel | csv files
Today we will learn:
1. How to refer values from excel/csv
2. How to iterate all the data from test data file
Code to get data from data file (findTestData)
Code to loop data source (getRowNumbers)
Step 1 : Create your test case
Step 2 : Create data file (excel/csv) and add your data
Step 3 : Create variables and refer in Test Case
Step 4 : Add your data file in Katalon Studio
Step 5 : Add your test case in a Test Suite
Step 6 : Click on Show Data Binding and add data
Step 7 : Save and Run
for(def rowNum=1; rowNum =findTestData("data1").getRowNumbers() ; rowNum++)
{
//WebUI.setText(findTestObject('Object Repository/Variables/Page_OrangeHRM/input_txtUsername'), Username)
WebUI.setText(findTestObject('Object Repository/Variables/Page_OrangeHRM/input_txtUsername'), findTestData("data1").getValue(1,rowNum))
//WebUI.setText(findTestObject('Object Repository/Variables/Page_OrangeHRM/input_txtPassword'), Password)
WebUI.setText(findTestObject('Object Repository/Variables/Page_OrangeHRM/input_txtPassword'), findTestData("data1").getValue(2,rowNum))
Thread.sleep(3000)
}
docs.katalon.c...
PLAYLISTS
KATALON STUDIO
• Katalon Studio
SELENIUM BEGINNERS
• Selenium Beginner Tuto...
SELENIUM JAVA FRAMEWORK BEGINNERS
• Selenium Java Framewor...
SELENIUM TIPS
• Selenium Tips
SELENIUM PYTHON
• Selenium Python
SELENIUM BUILDER
• Selenium Builder
JAVA
• Java
JAVA TIPS & TRICKS
• Java Tips and Tricks
JENKINS
• Jenkins
JENKINS TIPS & TRICKS
• Jenkins Tips n Tricks
JMETER BEGINNER
• JMeter Beginner
JMETER INTERMEDIATE
• Jmeter Intermediate
JMETER ADVANCED
• JMeter Advanced
JMETER TIPS & TRICKS
• JMeter Tips n Tricks
SOAPUI
• SoapUI
POSTMAN
• Postman Beginner Tutorial
GIT & GITHUB
• Git and GitHub
DOCKER
• Docker
ROBOT FRAMEWORK
• Robot Framework Beginn...
WEB SERVICES (API)
• API Web Services
REDIS BEGINNER TUTORIALS
• Redis Beginner Tutorials
MAVEN
• Maven
MISC
• Misc Tutorials
TOOLS & TIPS
• Tools and Tips
QnA FRIDAY
• QnA Friday
SUNDAY SPECIAL
• Sunday Special
ALL PLAYLISTS
/ @raghavpal
Follow on TWITTER:
/ automationsbs
Subscribe on KZbin :
/ automationstepbystep
_____