i have an excel sheet with 10 account numbers –
in the bank website i have list of some 50 accounts, i have to select(checkbox) only 10 account numbers that is matching with excel, help me with the coding.
Hi @senthil.it89,
Loop through each Account number and convert 5 account number as single string variable.Then get text from Each checkbox account number and use accountnumber.Contains(string value). If it matches click the checkbox.
Hope this will solve your issue. Feel free if you need any further help.
Happy automation
Hi @senthil.it89,
Read the excel file and find those value using hot key in website. if you found value then check it.
Hope this will help you.
Regards
Hi @senthil.it89,
-
Use Read Range to read the data from excel sheet. Output will be in the form data table.
-
Convert output data table to array yourdatatablename.AsEnumerable().Select(Function (a) a.Field(of string)(“yourcolumnname”).ToString).ToArray()
-
Now use find children activity to get all child elements under parent element.
In your case, child elements will be your checkbox. Parent element will be your div. -
Use for each to loop through the child elements.
-
Inside for each use get text to get account number. In the get text activity, properties pane pass the item in element field. Say output variable be Txt
-
after get text activity, use if inside if condition, Txt.contains(strArray) or StrArray.Any(function(x) Txt.Contains(x))
-
In then part add check box actvity and check it.
Hope this helps.