Define and apply data validation rules to cells with ExcelApplication. |
Excel Data Validation (in Excel the menu, Data > Validation...) allows you to control what kind of data can be entered into cells by creating validation rules. You can define and apply these rules with ExcelApplication.
Insert code from sample stored in SVN here |
Template: FirstYearPayment.xlsx
Output: DataValidation_output.xlsx