How to increase the numbers in a column

[pprin001 (Paolo70)]

Hello.

I’d like to automate this part increasing the values.

Desired output :

It will be larger than 6 but I need help with the logic, please.

I did it with fill range activity but It replicated the last number 2 in all the cells.

Help, please.

Thanks.

I’ve upload the excel file.
numbers.xlsx (8.2 KB)

[arivu96 (Arivazhagan A)]

Hi @pprin001,
Use read range activity to get the data into datatable.

Create intcounter=1 variable
Inside for each row
Assign row(“Id”)=intCounter.ToString()
&
IntCounter=IntCounter+1

Then use write range to write in excel.

Regards,
Arivu

[Sudharsan_Ka]

Hi @pprin001

First format the id column to number and then use autofill range activity

UiPath Tutorial | Uipath Auto Fill Range

Regards
Sudharsan

[Gokul_Jayakumar (Gokul Jai)]

Hello @pprin001
Refer to this Xaml file you may Get Some idea
Forum_NumberAutoFill.zip (143.2 KB)

Use Excel Modern Actvity.
If You are classic user, Enable activity vy following these steps:
Click Actvity pannel> Click Filter> Enablke the Show modern option.

[Gokul001 (Gokul Balaji)]

HI @pprin001

You don’t need to Use Assign activity for counter.

In the For each row in DataTable activity itself having the Index, So you can create the variable there.

Inside the Loop Use only one Assign activity

CurrentRow("Id") = indexCounter

Regards
Gokul