Applies an TwoConstraintDataValidationRule to the cells in a WorksheetRegion. Syntax Parameters rule The data validation rule to apply to the region.region The region to which the data validation rule should be applied. Exceptions Exception Description System.ArgumentNullException Occurs when rule is null. System....
Applies a data validation rule to the a set of references. Overload List
Removes all data validation rules from the Worksheet. Syntax
Determines whether the specified data validation rule exists on the Worksheet. Syntax Parameters rule The rule to test. Return Value True if the rule is applied to one or more cells on the Worksheet; False otherwise.
Determines whether the specified cell has a data validation rule applied to it. Syntax Parameters cell The cell to test. Return Value True if the cell has a data validation rule applied; False otherwise. Exceptions Exception Description System.ArgumentNullException Occurs when cell is null. System.ArgumentExceptio...
Determines whether the specified references collection has a data validation rule applied to any of its cells. Syntax Parameters references The references collection to test. Return Value True if the any cell from the references collection has a data validation rule applied; False otherwise. Exceptions Exception D...
Determines whether the specified region has a data validation rule applied to any of its cells. Syntax Parameters region The region to test. Return Value True if the any cell from the region has a data validation rule applied; False otherwise. Exceptions Exception Description System.ArgumentNullException Occurs wh...
Determines whether the specified data validation rule exists on the Worksheet. Overload List
Gets the number of data validation rules applied on the Worksheet. Syntax
Find the data validation rule applied to the specified cell. Syntax Parameters cell The cell to test. Return Value A DataValidationRule-derived instance or null if the cell has no rule applied. Exceptions Exception Description System.ArgumentNullException Occurs when cell is null. System.ArgumentException Occurs w...