Read range and create a variable with it

Help Studio
1

Hello,

I am searching a way to : read an excel cell (or Datatable), it contains a selector id that i have to store on a variable.

My goal is to click on a button in a website then perform a certain action.
Then do the same action with another button ( the selector will then change with the variable)
So i have already stored the id on a DataTable but i want read the first line which contains the first selector id.

I am new to uipath so i dont know if this is the right way to perform this action.
Thanks for your advice

2

@zSmiley Welcome in community.
Can you show me excel file template?, So i can suggest something to you.
I am getting your problem its minor issue which can be be solve by giving range

3

Hello @zSmiley

Here the motive is to make the selector dynamic. so you can loop through each row and get that row to a variable and then pass it as a dynamic variable to the selector.

Can watch the below video to understand the dynamic selector in better.

4

Hello,

I am sure this is pretty easy, but i feel like im missing a little step.

So I have many customers with their login and pass and I have to go download the same data, the only different is that the number of file is not the same so i used a find children to get the number to loop and the cursor id.

And i get

uipathselector
uipathselector746×757 24.9 KB

So my goal now is to loop with them.
So i want to Create a variable with the Range A&“number” (number will be 1 and at the end of the loop i will add +1)
When i try to read range it tell me that there is a problem with converting String to UiPath.Excel.IReadRangeRef.

I dont know if my approach is the right one.

Thanks in advance

5

Hi @zSmiley

Can you elaborate you query little bit? And share some sample input file with us.

Regards
Gokul

6

Hello,

I finally find the solution it was the read range that was not well configured, it finally worked.

Have a nice day

7

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