How to read data from a excel based on that data check in the corresponding checkbox in browser appln Uipath

Question

Uipath

I am using a web application in which there are few checkboxes

• English
• Chinese
• French
• German
• Japanese.

I have a excel datasheet, column name 'select language' cell : Chinese, German

How do i automate this so that my bot fetches data from excel and checks English and German checkboxes only.

I used Get attribute(mention dt), Check(selected element on screen i.e checkbox beside english)

Instead of fetching data from excel it is checking english(following the element on screen)

Pls help me on this.

Answer 1

Hi, to achieve this, you can perform following actions:

You can use Check Activity (which checks check-boxes) or a simple Click will also work. While using Click you will have to get the ‘State’ (checked or unchecked from the attribute of the check-box) and then in decision you have to either check or keep as it is. 

I hope this will help you!

Or please share your UiPath Sequence/Flowchart screenshot.

Comments

Thanks for your reply.

My problem is with getting data from Excel sheet, read the cell in order to check.

for example My excel cell contains German, English

My browser has 

• English
• Chinese
• French
• German
• Japanese

I want only German and English Check boxes to be checked.

I used Excel scope, read range but check box is not reading from that.

---

Hey Dhivya, instead of using Read Range activity from excel, use a for loop and add Read Row activity in it. Now put up If condition activity to check whether value from a specific cell is equal to English or German. And if value is matching then use this value to check the checkbox.