Katalon Studio | How To Get Data From Excel

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) } https://docs.katalon.com/display/KD/Manage+Test+Data PLAYLISTS KATALON STUDIO https://www.youtube.com/playlist?list=PLhW3qG5bs-L_D4ZePNNjvmIULuu6mBHbu SELENIUM BEGINNERS https://www.youtube.com/playlist?list=PLhW3qG5bs-L_s9HdC5zNshE5Ti8jABwlU SELENIUM JAVA FRAMEWORK BEGINNERS https://www.youtube.com/playlist?list=PLhW3qG5bs-L8oRay6qeS70vJYZ3SBQnFa SELENIUM TIPS https://www.youtube.com/playlist?list=PLhW3qG5bs-L-QcWg_3niY8_czGfYT6QZb SELENIUM PYTHON https://www.youtube.com/playlist?list=PLhW3qG5bs-L9JjtXx-adxWdbjaxeRhi7h SELENIUM BUILDER https://www.youtube.com/playlist?list=PLhW3qG5bs-L8X5gd41T_BgebxSVtzRNt9 JAVA https://www.youtube.com/playlist?list=PLhW3qG5bs-L_qj1L5hnHvJYeFpQ_g4UuU JAVA TIPS & TRICKS https://www.youtube.com/playlist?list=PLhW3qG5bs-L8SGvNCb9Nj66JZkWPwfZFc JENKINS https://www.youtube.com/playlist?list=PLhW3qG5bs-L_ZCOA4zNPSoGbnVQ-rp_dG JENKINS TIPS & TRICKS https://www.youtube.com/playlist?list=PLhW3qG5bs-L8T-0JT464rkIvnUz5q4CQC JMETER BEGINNER https://www.youtube.com/playlist?list=PLhW3qG5bs-L-zox1h3eIL7CZh5zJmci4c JMETER INTERMEDIATE https://www.youtube.com/playlist?list=PLhW3qG5bs-L-PpK83CC_m_bWd_722tvgk JMETER ADVANCED https://www.youtube.com/playlist?list=PLhW3qG5bs-L_Eosy1Nj1tKHC5jcBAVkPb JMETER TIPS & TRICKS https://www.youtube.com/playlist?list=PLhW3qG5bs-L-oMT1Cnrurt7gEaLrRub2V SOAPUI https://www.youtube.com/playlist?list=PLhW3qG5bs-L-Bt9T_bnyflQ0Te4VgFhKF POSTMAN https://www.youtube.com/playlist?list=PLhW3qG5bs-L-oT0GenwPLcJAPD_SiFK3C GIT & GITHUB https://www.youtube.com/playlist?list=PLhW3qG5bs-L8OlICbNX9u4MZ3rAt5c5GG DOCKER https://www.youtube.com/playlist?list=PLhW3qG5bs-L99pQsZ74f-LC-tOEsBp2rK ROBOT FRAMEWORK https://www.youtube.com/playlist?list=PLhW3qG5bs-L9l2I8K8dEhw6HXy-Z-33w3 WEB SERVICES (API) https://www.youtube.com/playlist?list=PLhW3qG5bs-L9E2KV6vVdB-YTk-sRxmRAB REDIS BEGINNER TUTORIALS https://www.youtube.com/playlist?list=PLhW3qG5bs-L8n1fsiT8z_VnDhnUk4vaVq MAVEN https://www.youtube.com/playlist?list=PLhW3qG5bs-L8XkBrI-G5aTUo6QwEEoVcj MISC https://www.youtube.com/playlist?list=PLhW3qG5bs-L8nTyDWDO24lXFLptaqrAKZ TOOLS & TIPS https://www.youtube.com/playlist?list=PLhW3qG5bs-L8dQYImOOArI1jaofMCc4hb QnA FRIDAY https://www.youtube.com/playlist?list=PLhW3qG5bs-L8r3wdQ3evX9mIZpHuwiDAj SUNDAY SPECIAL https://www.youtube.com/playlist?list=PLhW3qG5bs-L83XJnJyqvVdOjIaYlXSvUx ALL PLAYLISTS https://www.youtube.com/channel/UCTt7pyY-o0eltq14glaG5dg/playlists?sort=dd&view=1&shelf_id=0 Like on FACEBOOK : https://www.facebook.com/automationstepbystep Follow on TWITTER: https://twitter.com/automationsbs Subscribe on YOUTUBE : http://youtube.com/automationstepbystep _____