Uipath with excel

Help Studio
1

I have two lists , one is values(ie. Aaaa, Bbbb, Cccc) and another is cell name(“A”,“B”,“C”)

i want to loop the values at the same time cell name need to be changed.

2

@udhayakumar.A

Use for loop on one of the list…and in the for loop properties you have a property called index…which starts from 0 and increments for each iteration…assign a variable to it

And then inside loop currentitem will give item from first list and list2(indexvar) will give the value from second list at the same position

Hope this helps

Cheers

3

@udhayakumar.A

Screenshot 2023-03-22 163558
Hi You can use the above example of for each loop.
:+1:

1 Like
4

Hello Team,
I am using the last version of UiPath 2023, and the new for each for dataset reading show an error can you help please.

Capture d’écran 2023-03-22 111428
Capture d’écran 2023-03-22 1114282520×1262 140 KB

5

@yves_Somda

Please downgrade the system activities pckage then you will have an option to change the type arfument…please change it appropariately and use it

Cheers

6

@Anil_G
I am a newbie on uipack and I really don’t know how to downgrade the system activities package on UiPath Studio X. I am using a windows machine.

7

@yves_Somda
we would recommend

  • create a new topic for your,when more help is needed,as we prefer to have topics scoped to only one case
  • check the typeargument of the for each activity if it is set to DataTable

recommended first stop: UiPath Academy

8

@yves_Somda

Agree with @ppr

On studio x you can click on manage packages …and change the version from
The drop down you see for each pckage and click install and save

Cheers

9

it didnt work ,because I am already writing in the same workbook , so it shows the it is already in use.

10

@udhayakumar.A

The question was something else here…

Cheers

1 Like
11

Thank you guys,

I finally find a solution by downgrading the system activity package as suggest by @Anil_G,

1 Like