Data Files: Iteration doesnt stop at empty row

Need to fix the following
Delete the contents of a row in the excel by selecting the row cells and clear contents. In this case, katalon doesnt exit data iteration after first iteration. It takes the second row and continue with test execution.
Katalon should exit the iteration if the first cell in the next row is empty or any otherbetter solution. Currently it only stop if I right click on the row and delete the row

Hi Manu,

Please see the link below. Seems like your issue is the same with this:

You can refer to my answer on that link and try it on your side.

Hope that helps. . . :slight_smile:

yes it is. I had already figured that out… Can you add a feature to katalon to automatically stop iteration on a blank row

Hi Manu,

On iteration, if you want to stop it when it detects a blank value you can just put a condition and break the loop something like:

Object excel = ExcelFactory.getExcelDataWithDefaultSheet(“yourDataSourcePath”, “sheetName”, true)
for (int rowCounter = 1; rowCounter <= excel.getRowNumbers; rowCounter++)
{
if (excel.getValue(“ColumnName, rowCounter”) == “”)
{
break
}
}

Hope that helps. . . :slight_smile:

Thanks @7314-Arnel
I have already implemented it. I was wondering if it can be take care by katalon iteration feature. like without that extra coding