Excel file on my local computer with a column header labeled "Sex," where "F" represents female and "M" represents male

Help Studio
, ,
1

I have an Excel file on my local computer with a column header labeled “Sex,” where “F” represents female and “M” represents male. I want to automate data entry on a web form, where the process selects the appropriate checkbox based on the value in the “Sex” column. Could you explain how to do this?

i have read see this but i cant understand how to do
Follow the below steps,

  1. Use the For each row in datatable activity to iterate the each row in the datatable.
  2. Inside for each insert the If condition to check weather it will empty or not.
  3. Inside Then block insert Assign activity to store the value in a variable.
  4. After Assign activity drag and drop an Click activity and indicate on the First option then open the selector option.
  5. Then open the Ui explorer and Check the aaname or visibleinnertext attribute.
  6. Then you can pass the Variable which is created in assign activity to make it dynamic.

I some can give me image sample

2

Hi @Arlyn_Malalay
“Inside Then block insert Assign activity to store the value in a variable.”

Add one more if condition in then block and check the value as “F”, if it’s contains, click “female” value or else click “male” Value

Thanks,
Muthuraj

3

i new to UiPath 3day ago im still exploring and learning
i don’t have idea how to build only i follow youtube video maybe someone can give me image how to build and to read my the excel fiel the gender then automate on web to select check box would be great

4

Hi @Arlyn_Malalay

I hope this XAML will be helpful to you.
ExcelAutomation.xaml (15.1 KB)
Input.xlsx (8.6 KB)

Thanks,
Muthuraj

5

Thank you so much it works now

1 Like
6

Hi @Arlyn_Malalay

You did the correct process.
After you passing the variable to the aaname attribute in Ui explorer is it working or not.

7

image
image889×901 46.6 KB

@mkankatala
thanks for help im still learning i want to automate this data entry for this site

https://webapp.es2.immd.gov.hk/applies2-client/fdh/en-US/entry/dvaDeclaration

For this site it would be great help if someone can help me to atumation this whole process

8

You are asking us to automate the process… @Arlyn_Malalay

We are unable to access the website.

9

@mkankatala

Site

image
image1202×557 58.2 KB

This is site where i want to automate where data came from my excel sheet.

it would be a great help if you can help me to automate this im still on 1week learning UiPath

im still checking if the UiPath can solve our problem before we get the license to im using 30days trial