Loop in Excel for take id one by one

Help
1

Hay, I need a loop for reading excel file just id column one by one row. I add Excel Application Scope and Read Range. Then i put Assign i=0, and then id from excel = output(i).To String. What I need to do next. Please help me. I need that id one by one to download some document from browser.

2

@Tinkerbell,

You can loop through the excel like this :
image

Everytime it will pick the next value in the excel as you are increasing the value by 1. Make sure you have assigned the value of count to 1 so that it can pick the values from second row

3

image
image818Ă—97 11.5 KB

yes, but I need add in loop first two column. I add something like this.
image
image392Ă—624 11.3 KB

Make sense?

4

Can you please elaborate a bit… I don’t understand you

5

Hey @Tinkerbell

When you use the Read Range activity it gives you the result as Datatable.
-Next step is to iterate the datatable and get the id column value to

Untitled
Untitled1366Ă—768 71.2 KB
use it further.

6

If you are storing the entire excel data into a datatable, then you just need to pass the column name to the row object.

image

7

Ok, i need to open the excel and read the first and second column. I read the first column and take a data one by one. I’ll search for that number on browser and download the document. Then I need another column to do the names. And as I handle it, I have to go back to the excel document and move on to the next one(row)

8

As in the above screenshot, you will get the value that is required, then do all the operations within the for each row activity. So that it will download the document and then loop for the next value

9

Hi @Tinkerbell ,

For that, you don’t need any (i) variable.
You are already looping your datatable so every time you will get the next row data in your (row) variable.

Just make the type as String in your ForEach Row loop. and assing the first column as row(0). Assign the second column as row(1)…and so on.

Regards,
Hemal

10

I do that but isn’t working.

image
image542Ă—667 13.2 KB

They always get me just a first number.

11

you need to replace row(0).toString to row(“desired column name”) to get the values.
by using row(0).to string() you are getting the values from row 1 only every time.

12

You don’t have to change anything. Just change the type as String from your ForLoop property.

Regards,
Hemal

13

it’s possible that you don’t have more data in your excel file. Just check it once.

14

I did, but robot do the some again. What I need add to tell the robot go on next.

image
image408Ă—564 11.1 KB

15

I haw data I check. Sorry I don’t understand what I need to change in string?

16

Can you please make your loop outside of this excel scope ? Might be because of it.

Regards,
Hemal

17

Noup, it takes just a first row I try. I need to tell them to go on next somehow.

18

sorry I forgot. It’s For Each Row.

19

It’s impossible.

Can you send me the screenshot of your read range activity ?

Regards,
Hemal

20

can you please make the range as “A1:K20” in your read range activity ?

Just for the testing purpose, if it’s working or not !

Regards,
Hemal