I need to create the drop down in an excel in the column P
the dropdown should reflect for the each cell in the column P
for example Coding trending is the column header in P column(i.e. P1 contains the header name as Coding trending)
below the cell P1 i.e, remaining cells like P2, P3, P4 and so on should contains the dropdown with the values “No Change”,“Upcoded”, “Downcoded”,“Others”.
As it is a static dropdown that you need…it is better to create a excel with dropdown in it and then paste the data from UiPath to the excel by copying the template
That is a static dropdown itslef…you just need to create report daily using same template which you configured already and change the values…but if you still want to do from UiPath only then you have macros…please check the post shared by @Harshith_Adyanthaya
It wpuld be dynamic when you need to create a dropdown with different values daily…rather than same set of values
Could you check with these steps and let me know if it works for you.
Read the Excel file into a DataTable using the Read Range activity.
Use the Add Data Column activity to add a new column to the DataTable with a name of your choice (e.g., “Validation”).
Use the Write Range activity to write the modified DataTable back to the Excel file.
Use the Excel Application Scope activity to open the Excel file and select the sheet you want to work with.
Use the Range activity to select the cells in the column where you want to create the drop-down list (e.g., “P2:P1000”).
Use the Data Validation activity to create the drop-down list in the selected cells. Set the validation type to “List” and the formula to “={“No Change”,“Upcoded”,“Downcoded”,“Others”}”. Make sure to check the “In-cell dropdown” option
Use the Save Workbook activity to save the modified Excel file.