What is if condition for select check box according to value match in web and excel

Help Studio
1

hello…i want to select checkbox according to value match with excel and web. i have to use click activity for that because there is image in checkbox. so how match excel checkbox value and excel checkbox value in if condition. value include TRUE/FALSE.

Thank you…

2

@Rutva_Patel

Check below post

Use Write Cell activity to write the formula inside the Excel

Use For Each row activity and use IF condition inside that

Now write Row(“ColumnName”).ToString = “TRUE”

Then->Place your Click activity

Hope this will help you

Thanks

3

@Srini84 i think you see this problem in worng way. i want to click on checkbox which is in web but input value for check box is in excel so if in excel there is TRUE so i want to click on checkbox if it is FALSE than uncheck that…

4

@Rutva_Patel

Use For Each row activity and use IF condition inside that
Now write Row(“ColumnName”).ToString = “TRUE”
Then->Place your Click activity

Hope this will help you

If not then share your sample of Excel

Thanks

5

Hi

Did we Check with this thread for a similar issue

Cheers @Rutva_Patel

6

ab
suppose checkbox is already check means value is TRUE and excel value is also TRUE… so have handle that situation. @Srini84

7

@Palaniyappan this is different i don’t want check in Excel. i want in web

8

Yeah but with that you can know whether the excel check box is checked or not
Based on which you can check in web page

Cheers @Rutva_Patel

9

Got it

So the steps would be

  1. Use a excel application scope and pass the file path as input and get the output as a datatable named dt with read range activity

  2. Now use a for each row activity and pass dt as input

And inside the loop use a IF condition like this

CurrentRow(“DND”).ToString.ToUpper.Equals(“TRUE”)

If true it goes to then block where you can use attach browser activity
within that attach browser use a CLICK or CLICK IMAGE ACTIVITY to check that box in web site

Cheers @Rutva_Patel

10

@Rutva_Patel

Use For Each row activity and use IF condition inside that
Now write Row(“ColumnName”).ToString = “TRUE”
Here you can add another step in Then
Use Get Attribute activity Checked and check it is checked on that later you can place your logic

Then->Place your Click activity

Thanks

1 Like
11

Grate…it’s work…Thanks @Palaniyappan

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.