Write number in a sequence Range excel

Hello Friends,

I want to insert a range in sequence of numbers…


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


1 Like


Could you please tell more details for better understanding.

1 Like

you already go the answer
“Sequence” - “looping”
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


you may try with “flash fill” in MS excel


use short cut key CTRL + E …