Excel Gender Column Into Web

Hi,
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
krishnareddy

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