You should make a loop that cycles through your code as many times as you need, or as many rows you have in your spreadsheet. You can find examples on this forum how to do that. Here is one example:
Name
Age
Person 1
20
Person 2
21
Person 3
22
Person 4
23
How to loop this exel sheet data in katalon
I have to fetch each Names and corresponding Ages using katalon
How i can implement this in katalon
For this statement , you would have to change it so that your spreadsheet is read instead, such as:
The documentation for this was not much help, so in case somebody else searches for this hopefully this will help.
First of all I created new test data file pointing at my excel file
[Image: https://s3.amazonaws.com/katalon-forum/editor/gr/0zyvsxk27bzp.png]
Then I looped through printing out the names using the following code in my test case
import static com.kms.katalon.core.testdata.TestDataFactory.findTestData
TestData data = findTestData('mydata')
for (def index : (0..data.getRowNumbers(…
Thanks Timo for your help!!!
I was using findTestData( ) and getValue( ) methods from katalon studio API.
below is snippet:
WebUI.setText(findTestObject('Object Repository/Page_Login Salesforce/input_Username_username'), findTestData('Automation Test Data').getValue(
'UserName', 1))
WebUI.setEncryptedText(findTestObject('Object Repository/Page_Login Salesforce/input_Password_pw'), findTestData('Automation Test Data').getValue(
'Password', 1))
If I have to…