How to Select drop down value from Excel

Help Studio
, ,
1

Hi , I need to select month from a drop down list inside an excel file, how to do it using Uipath ? this is monthly BOT each month Bot to pick current month, any help.

image
image

2

Hey @monishanair2010

Could you please confirm if that’s a drop-down component or just a cell in Excel with allowed list of values ?

Also if you can please share the Excel here, would be helpful.

Thanks
#nK

3

Hi,

If the dropdown is from DataValidation feature, can you try to use write cell as the following?

image

Regards,

4

Hi @Yoichi - write cell did not work , not selected that value instead it wrote the value next to the cell in the same row.

5

Hi,

Can you share the workbook as a file if possible? It’s no problem if dummy data.

Regards,

6

@Yoichi - Unfortunately I wont be able to share the workbook , it a drop down component inside an excel

7

@Nithinkrishna - sorry unfortunately I cant share that excel, but its a drop down component with list of Months

8

Okay np. Let’s simulate and try.

Will feedback on this.

9

@Nithinkrishna - thank you Nithin

1 Like
10

@Nithinkrishna - any luck ? did you get a chance to simulate ?

11

Haven’t tried yet @monishanair2010

Will update hopefully tomorrow.

1 Like
12

@Nithinkrishna - did you get a chance to try ?

13

I tried with ALT+Down arrow is not working :frowning: