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 in RPA by anonymous
• 120 points
30 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 by Abha
• 24,980 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 in RPA by Shivi Singhal
3,402 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 in RPA by Anvi
• 13,400 points
4,952 views
0 votes
0 answers

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

Sep 12 in RPA by anonymous
• 120 points
81 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 3 days ago in RPA by Abha
• 24,980 points
12 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,110 points
1,366 views
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,110 points
97 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 in RPA by Abha
• 24,980 points
173 views