Increament cell by 1 for each iteration

Help Studio
1

Hi, I’m writing a range to excel but the data is overwritting on the same cell for each iteration. May I know how to increment cells for each iteration

IMG_20201013_153728236
IMG_20201013_1537282361536×2048 1.74 MB

2

@Muthulakshmi_Thangamuthu

Use Index of the For Each in properties

Declare a variable for Index, then you can increment

Eg: IndexVariable = IndexVariable + 1

Also you can follow how you can use write range using Datatable here Link

Thanks

3

“A” + (count+1).Tostring

4

16025851919856243826424933533785
160258519198562438264249335337851536×2048 1.26 MB

Thanks for the reply. I tried but still it’s over writting in the same cell.

5

May I ask: do you stop > start > stop > start your workflow? Because when you do you set your counter to 0 and start overwriting your cells.

6

What is the scope of your indexes variable? is it ‘For Each’, if yes then please increase the scope of it and try to execute it.

7

@Muthulakshmi_Thangamuthu
For just appending the new data have a look on the append range activity: