Please clarify doubt in Building datatable

[Boopathi (Boopathi Manogar)]

1. Assigned a value to a variable SRGroup
2. Built data table using single column name SR Group
3. Added data row and writing in excel also

4.? Now when i run the bot next time it should not overwrite the existing values in excel. It should skip the row if the value is already in and start from the next row. Please help me on this

Thanks,
ulaga

[Rammohan91 (Rammohan Banda)]

@Boopathi

when i run the bot next time

By this do you actually mean running the robot for the second iteration and not the 2nd instance of the loop for the same run.

In that case, ‘Write Range’ activity won’t work since it will always overwrite the datatable with the new row value and will inturn overwrite the excel data.

You can try using ‘Append Range’ if that’s how you wanna build, however you datatable will still have only 1 row.

If you want to use loop, then you may wanna have a look at this thread once,

How to loop through rows and columns in an excel and pass them to a webpage

Hi, I need to capture data from each row and each column and pass them to a webpage to login. Excel: usrname password user1 pswd1 user2 pswd2 user3 pswd3 webpage username-textbox password-textbox How do i do this? I started of by Read Range activity to read data present on the excel. created a variable to read the column count in to. I am looking for how would i fetch and pass them to webpage in a loop

Thanks,
Rammohan B.

[Boopathi (Boopathi Manogar)]

@Rammohan91 Thank you. Got it.