Ask a Question

Excel loop not stopping after finishing the Data

Occasional Contributor

Excel loop not stopping after finishing the Data

Hi Everyone,


Here I am using Data loop and there I have imported my excel file from my local. 


here I Have 30 rows data excluding Header, my script entered the 30 rows of data and it's trying to enter the data from 31st row(which contains no value or data)

Could someone help me to figure this out. I also gone throught the videos on testcomplete website. there no body used stop function or any other. Just imported the excel file and assign the coloumn data. I also did the same, but it's lopping even after completed with all data.


Thank yo


Hi @vantaku01 


When configuring the data loop there is an option to set the "First row contains column names"


On the next screen you then have the option to run the file from the beginning to the end or alternatively you can run up until record 30 to avoid any unwanted data being processed; 




Please let me know if this helps.

Kind Regards,




Occasional Contributor

Thank you so much  Shane,


The above solution got worked. But whenever we added new rows of data, it should adapt to the end of data. 


if we use the above steps, we should update the " To Record " every time. Then this wouldn't be an automation. 


If we observe the lectures from smartbear, they haven't used the section "To Record". They always used the function " To the End".


Thank you so much for your response.






Most probably, your Excel file contains blank rows. Search for them and delete.

For example:


  /Alex [Community Champion]
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
Showing results for 
Search instead for 
Did you mean: