Using Data Validation in Excel Using BluePrism Code Stage


I need to use the data validation in Excel. It is like inserting a list of values in cells of Excel in the form of dropdown/list. Could someone help me with that please?


Well-Known Member
Staff member

As you can refer in the links (Link1, Link2) as to how the validation method is used with the Range object, you can create you own Code stage and use it along with a range where you want to set the Data Validation. You will find code in the forum that access an excel sheet and uses the range object in the code. So you can make use of them.
For excel related constants (like xlGreaterEqual) also you will find solution on the forum on how to provide its corresponding numeric constant in place of the excel constants.