Excel Gender Column Into Web

I have a excel sheet with column “Gender” as ‘M’ AND ‘F’.I want to enter that data into web it has radio buttons.How to do this please help me.

thanks in advance

Hi @krishnareddy
Kindly follow the below steps that could help you resolve this issue
–use a excel applicatin scope and pass the file path of the excel as input
–use read range activity and get the output as a datatable variable named out_dt
–use a for each row loop and pass the variable out_dt as input
–inside this loop use a if condition like this
if row(“Gender”).ToString.Equals(“M”)
it will go to THEN part where
use a click image or click activity that clicks on M radio button
or it will go to ELSE part where
use same click to click on F radio button
Cheers @krishnareddy

1 Like