I want to add drop-down in the excel file

in the Above excel file, I want to add Dropdown for confirmation and Issues Column.

• Confirmations column drop-down contain option like:
- Yes
- No
• Issues column drop-down contain option like:
- Discontinued
- Pricing
- Licensing
- Minimum

How to do this in uipath?

All Above excel file data is stored in the data table.

@sambulkar,

You want to do it in UiPath or with excel options, if excel options then see this page

1 Like

I want to do it in uipath

@sambulkar,

You have to do the following actions to get the dropdownlist.

Open Required Excel using excel application scope
Attach excel window, then using Goto excel option navigate to the required cell.
Use send hot key activity with keys - Alt + A + V + V

It will open the data validation window
Use Element Exist activity to identify the window displayed
Attach that window and in the allow dropdown list select “List” item
Then in the Source “=$E$3:$E$7” if you have the dropdownlist items in the E column from cell 3 to cell 7
Click on Ok button, now dropdown will be created.

1 Like

I will try this one.