If a cell contains partial text click this tab

Help Studio
1

Hi i am new to UIPATH. In my project, i need the robot to detect the cell values in Column K in tab “AA12a” and then take only the first letter +1/2/3 and go to that specific tab. is there any possible way to do this?

123
1231920×738 188 KB

2

Hi @shira1

Yes its possible

You need to first read the data into a datatable using read range. Then loop through the table to find the first letter of column k. In loop just use currentrow(10).Tostring.tochararray(0) this will give you first letter… and then you can use it in sheet to read that sheet

Cheers

3

Hi @Anil_G thank you for replying to me!

upon completing the loop, how do i get the robot to click on the tab for me? for example, if the cell says “T - Expenses”, i want the robot to click on the “T1” tab.

Thank you!

4

Hi @shira1

Ideally uou should not be doing exce automation like this… but if you still want to click then first identify the selector for tab and then in that you will have an attribute for name… pass the T1 to that name and it should click

If the issue is solved please mark the solution so that others alao can get help

Cheers