For each row loop return row number

Help Studio
1

kinda embarrassed to ask this … and I know the answer is something really simple

when, I’m looping through, how do I return the current row number ?

(I know I could create a int and just count that but there must be an inbuilt variable?)

2

@hughabbott - You mean cell address ? like A22, B15 etc…

3

Hi @hughabbott
There is an index property in for each row which returns the row index of current row

4

could you give me an example.

row.index or something like that ?

5

actually, I thinking about a “For Each Row” activity.

If I wanted to have a message box tell me which row is the current row number … how might I get that ?

6

Hi @hughabbott
Check this workflow
Main.xaml (7.5 KB)

Regards

Nived N

Happy Automation

7

Nived - I wonder if you might type in the line of code ( I could not open the xaml file because of a version conflict )

thanks for your help thusfar.

Hugh

8

Hi @hughabbott

image
image1305×737 26.7 KB

Here index variable is created in index property of for each row

Please Note

Regards

Nived N

Happy Automation

9

Hello if the intention is to discover an excel line to write in it, I use the following method.

The activity (LookUp Range) does a search in excel for something of your criteria, a text for example, and returns the cell, except for A5, then you save it in a Var.

To write in excel in C5 for example.
Use Write Cell, and as input Var.Replace(“A”, “C”)

Write in the cell, in the line with the value found, but in column C.

busca_excel
busca_excel765×1329 72.4 KB

excel_look
excel1

Main.xaml (10.2 KB) teste.xlsx (9.1 KB)

1 Like
10

image
image1274×574 24.7 KB

I wonder what I am doing wrong ?

11

Can u show the property panel of match address?

12

image
image1418×632 26.2 KB

hmmm I think i understand now

13

I get it now … I thought the there was some kind of reserved word for index, I did not know you set it each time to your own variable.

I knew it was a very basic error … now I get it.

sorry for being stupid :slight_smile: !

and thanks for your help

1 Like
14

You can get index of a particular row using below code, @hughabbott
Integer_Value = DataTable.Rows.IndexOf(row) and DataTable will be same which you pass to the For Each Row Activity.
Hope this may help you :slight_smile:

4 Likes
15

I found this very helpful. It’s working.

1 Like