Forum Discussion

vantaku01's avatar
vantaku01
Occasional Contributor
2 years ago

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...
Desktop Testing
Keyword Tests
Script Tests
  • SBegley's avatar
    SBegley
    2 years ago

    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,

    Shane

     

     

vantaku01's avatar
vantaku01
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.

 

Regards,

Ramesh.