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

0 votes

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.
Oct 9, 2019 in RPA by anonymous
• 120 points
2,493 views

1 answer to this question.

0 votes

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.

answered Oct 10, 2019 by Abha
• 28,140 points

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.

Related Questions In RPA

0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
13,887 views
+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,150 points
21,629 views
0 votes
1 answer
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
2,091 views
0 votes
1 answer

How to connect to a database from UiPath and read data from it?

Hi Pratibha, to connect to a database ...READ MORE

answered Oct 17, 2019 in RPA by Abha
• 28,140 points
8,913 views
0 votes
1 answer

How to read Month and Select Start & End Date from a Calender in Uipath?

Hello Apeksha, If you need start date of ...READ MORE

answered Oct 23, 2019 in RPA by Anvi
• 14,150 points
5,686 views
0 votes
1 answer

How to get the keys on the basis of corresponding values from a dictionary?

Hi there, if you need to get ...READ MORE

answered Oct 23, 2019 in RPA by Anvi
• 14,150 points
903 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered Aug 19, 2019 in RPA by Abha
• 28,140 points
4,134 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP