Katalon - get the number of rows in excel

How do I get the amount of rows from an excel file? Let’s say I have a button and for each row katalon needs to press the button once. How would I do this? Thanks in advance!

1 Like

Hello @Funkey
Using Test suite approach (like this video for example), you will run the test case as many as rows in excel file, that is, in your test case you will have any line that press the button, and the Katalon will run the amount of your excel rows.

I don’t know if its comprehensive

1 Like


try to read your excel to list and then will iterate list in your test case

1 Like

'The below code will print no of rows in the excel. "
System.err.println findTestData(‘YourDataFileName’).getRowNumbers()


Thanks for the answer exactly what I needed!