I want to click dropdown list which is in excel click the drop down list take one record
save as pdf again next click dropdown list take 2nd record save as pdf likewise in UiPath
From my experience with data validation, it does not care that you use the dropdown; if you pass the exact value of a dropdown item in the validation cell, then it will accept it.
If the dropdown values are always the same, then simply write the dropdown into an array variable in UiPath and do a for each loop with your excel activities inside of the loop.
Probably not the ideal solution here, but you could creat a macro using VBA to get all values in the dropdown into an excel file: https://officetricks.com/vba-read-values-in-data-validation-drop-down-list/
You can call the macro from inside your UiPath project which would create a new excel file listing all validations values within your workbook.
Then you could read the excel file with your validations into a UiPath data table. Then use a for each row in data table with your excel action inside of the for each row and pass the values into your excel file drop down.
If you wanted, this could all be done using VBA and you could just call your macro from within UiPath.
Good luck!
Hey
just create an array of your strings that you will need to write, then loop through your array and pass each variable into a write cell activity, then use the save as PDF activity
Regards
I want to make salary slip automation using UiPath can u send solution for this.