Write number in a sequence Range excel

Hello Friends,

I want to insert a range in sequence of numbers…

image

How can I do this, whithout to use for each ?

Thanks!!

1 Like

@Diego_Pin

Could you please tell more details for better understanding.

1 Like

Awesome
you already go the answer
“Sequence” - “looping”
Like
Use a excel application scope and pass the file path
—inside the scope use a while loop and mention the condition like this
Counter <= 10
Where counter is a int32 variable type with default value as 2 defined in the variable panel
—now inside the loop use a WRITE CELL activity and mention the input as counter.ToString and in the cell mention as ”D”+(counter-1).ToString
And mention the sheet name

Cheers @Diego_Pin

hi

you may try with “flash fill” in MS excel

or

use short cut key CTRL + E …