I have a datatable pulled from a SQL query. I would like to add a column on it that only allows the option of being “Yes” or “No”. For that added column, I have changed the type to “documentformat.openxml.office.customui.dropdown” which I would assume is the type I need but I’m not sure. In additio…

You can also create this by invoking code if that would be more efficient. Here is some sample code and test file that you can easily adapt to your needs. Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Exc…

[image] Drop-down List in Excel Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values. Like this you want…? its possible if you use macros i guess.

for you Reference [image] Create dropdowns in excel Help Hi @Rhitam_Deb u can use VBA code from background 2.otherwise click-> data menu in excel file and click-> Data Validation->setting->list->select the source and click ok

Thank you for all the responses. I will check some of this out this morning and see if I’m successful with it.

Creating Excel with dropdown option

Help

prakaz25 (Prakash M) June 20, 2019, 10:21am 3

for you Reference

Topic		Replies	Views
How to create the dropdown in the excel? Activities excel , activities , question	9	1946	December 11, 2024
Create Dropdown in Excel Help robot , studio	2	1854	September 28, 2019
How to create a drop down in excel with uipath Activities uiautomation	12	1884	August 12, 2022
Create dropdowns in excel Help activities	3	1417	May 21, 2021
I want to add drop-down in the excel file Studio	7	2000	August 9, 2022

Creating Excel with dropdown option

Related topics