How to select dropdown form excel

[Mathkar_kunal]

Hello,

I need to check/varify selcted value in drop down is applicable or not if not then i need to switch to “applicable”

means if not applicable is already seelcted then

my expected output is -

i have more fields aswell to do this in excel.
is any excel activity is there to select dropdown values in excel?
how can i achieve this?
help me on same.

[arivu96 (Arivazhagan A)]

Hi @Mathkar_kunal ,
Refer below link

UiPath Excel Dropdown list select

Regards,
Arivu

[Mathkar_kunal]

activity of balareva which showed in video is not available.
beow is the image form you tube video

[Prashanth_D (Prashanth_dharavath)]

Hi @Mathkar_kunal,

You can try out these steps provided in this case. Check the cell value; if it is not applicable, then use the steps provided below in this post.

How to Select Item From Dropdown Inside Excel File?

You can try this : Use Excel Application Scope to open the excel sheet. Select Range - point to which ever cell that has the options Type into “[k(alt)]avv” Shortcut to go to Data Validations that has the options listed Get Text from the source field to get all options. Check if your option is available in the list. If yes, then get the position of the option (1st / 2nd / 3rd / …) Click OK or cancel to dismiss the window. You can either write the option using Write Cell , which ideally ov…

Cheers!

[somyajain45]

you can open excel by marking check on visible checkbox in excel activity. Then use ctrl + g to go to the cell. Using hotkeys for traversing to cells is a good option here. then use hot key again to press enter and down arrow to change the value. you can use write cell plus hot key also

[Anil_G (Anil Gorthi)]

@Mathkar_kunal

you can directly use a write cell and write the exact value and it should be preserving the value

cheers

[ashokkarale]

@Mathkar_kunal,

You can use VBA macro code for this. Just record the interaction and make the code dynamic to select the dropdown item