How to directly get the Number of row in a "for each" function?

Help Activities
, ,
1

Hello.Last time i learn from Mr.Yoichi, i know how to directly get the number of column,thanks a lot. And i want to ask whether UiPath have a direct way to get Number of row like below picture which was sent by Mr.Yoichi :

image
image702×576 17.8 KB

Because when i use the activity “for each excel row” , i can’t directly extract the time of cycles as variable. If have a way can extract the time of cycles, it will be great. :smiley_cat:

2

@z1185399190

for each has an interation count variable in the properties…you can use that and get the row count

also if from excel you want to know then can use Excel.Sheet("SheetName").RowCount as well will give the count

cheers

3

have a look at this ootb variable:

grafik
grafik806×813 52.4 KB

4

Thank you very much~

1 Like
5

Thank you very much~I solve my problem :smiley_cat:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.