A collection of instances in a worksheet.
Inheritance
object
Implements
- IDictionary<DataValidationRule, WorksheetReferenceCollection>
- ICollection<KeyValuePair<DataValidationRule, WorksheetReferenceCollection>>
- IEnumerable<KeyValuePair<DataValidationRule, WorksheetReferenceCollection>>
- IEnumerable
Properties
Section titled "Properties"Count
Section titled "Count"Gets the number of data validation rules applied on the .
public int Count { get; }this[DataValidationRule]
Section titled "this[DataValidationRule]"Gets or sets the references which have the data validation rule applied to it.
public WorksheetReferenceCollection this[DataValidationRule rule] { get; set; }Methods
Section titled "Methods"Add(AnyValueDataValidationRule, WorksheetCell)
Section titled "Add(AnyValueDataValidationRule, WorksheetCell)"Applies an to a .
public void Add(AnyValueDataValidationRule rule, WorksheetCell cell)Parameters
- rule:
AnyValueDataValidationRule - cell:
WorksheetCell
Returns any
Add(AnyValueDataValidationRule, WorksheetRegion)
Section titled "Add(AnyValueDataValidationRule, WorksheetRegion)"Applies an to the cells in a .
public void Add(AnyValueDataValidationRule rule, WorksheetRegion region)Parameters
- rule:
AnyValueDataValidationRule - region:
WorksheetRegion
Returns any
Add(CustomDataValidationRule, WorksheetCell)
Section titled "Add(CustomDataValidationRule, WorksheetCell)"Applies an to a .
public void Add(CustomDataValidationRule rule, WorksheetCell cell)Parameters
- rule:
CustomDataValidationRule - cell:
WorksheetCell
Returns any
Add(CustomDataValidationRule, WorksheetRegion)
Section titled "Add(CustomDataValidationRule, WorksheetRegion)"Applies an to the cells in a .
public void Add(CustomDataValidationRule rule, WorksheetRegion region)Parameters
- rule:
CustomDataValidationRule - region:
WorksheetRegion
Returns any
Add(DataValidationRule, WorksheetReferenceCollection)
Section titled "Add(DataValidationRule, WorksheetReferenceCollection)"Applies a data validation rule to the a set of references.
public void Add(DataValidationRule rule, WorksheetReferenceCollection references)Parameters
- rule:
DataValidationRule - references:
WorksheetReferenceCollection
Returns any
Add(DataValidationRule, WorksheetReferenceCollection, bool)
Section titled "Add(DataValidationRule, WorksheetReferenceCollection, bool)"Applies a data validation rule to the a set of references.
public void Add(DataValidationRule rule, WorksheetReferenceCollection references, bool overwriteExistingRules)Parameters
- rule:
DataValidationRule - references:
WorksheetReferenceCollection - overwriteExistingRules:
bool
Returns any
Add(ListDataValidationRule, WorksheetCell)
Section titled "Add(ListDataValidationRule, WorksheetCell)"Applies an to a .
public void Add(ListDataValidationRule rule, WorksheetCell cell)Parameters
- rule:
ListDataValidationRule - cell:
WorksheetCell
Returns any
Add(ListDataValidationRule, WorksheetRegion)
Section titled "Add(ListDataValidationRule, WorksheetRegion)"Applies an to the cells in a .
public void Add(ListDataValidationRule rule, WorksheetRegion region)Parameters
- rule:
ListDataValidationRule - region:
WorksheetRegion
Returns any
Add(OneConstraintDataValidationRule, WorksheetCell)
Section titled "Add(OneConstraintDataValidationRule, WorksheetCell)"Applies an to a .
public void Add(OneConstraintDataValidationRule rule, WorksheetCell cell)Parameters
- rule:
OneConstraintDataValidationRule - cell:
WorksheetCell
Returns any
Add(OneConstraintDataValidationRule, WorksheetRegion)
Section titled "Add(OneConstraintDataValidationRule, WorksheetRegion)"Applies an to the cells in a .
public void Add(OneConstraintDataValidationRule rule, WorksheetRegion region)Parameters
- rule:
OneConstraintDataValidationRule - region:
WorksheetRegion
Returns any
Add(TwoConstraintDataValidationRule, WorksheetCell)
Section titled "Add(TwoConstraintDataValidationRule, WorksheetCell)"Applies an to a .
public void Add(TwoConstraintDataValidationRule rule, WorksheetCell cell)Parameters
- rule:
TwoConstraintDataValidationRule - cell:
WorksheetCell
Returns any
Add(TwoConstraintDataValidationRule, WorksheetRegion)
Section titled "Add(TwoConstraintDataValidationRule, WorksheetRegion)"Applies an to the cells in a .
public void Add(TwoConstraintDataValidationRule rule, WorksheetRegion region)Parameters
- rule:
TwoConstraintDataValidationRule - region:
WorksheetRegion
Returns any
Clear()
Section titled "Clear()"Removes all data validation rules from the .
public void Clear()Returns any
Contains(DataValidationRule)
Section titled "Contains(DataValidationRule)"Determines whether the specified data validation rule exists on the .
public bool Contains(DataValidationRule rule)Parameters
- rule:
DataValidationRule
Returns any
Contains(WorksheetCell)
Section titled "Contains(WorksheetCell)"Determines whether the specified cell has a data validation rule applied to it.
public bool Contains(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
Contains(WorksheetReferenceCollection)
Section titled "Contains(WorksheetReferenceCollection)"Determines whether the specified references collection has a data validation rule applied to any of it's cells.
public bool Contains(WorksheetReferenceCollection references)Parameters
- references:
WorksheetReferenceCollection
Returns any
Contains(WorksheetRegion)
Section titled "Contains(WorksheetRegion)"Determines whether the specified region has a data validation rule applied to any of it's cells.
public bool Contains(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
FindRule(WorksheetCell)
Section titled "FindRule(WorksheetCell)"Find the data validation rule applied to the specified cell.
public DataValidationRule FindRule(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
GetAllReferences(DataValidationRule)
Section titled "GetAllReferences(DataValidationRule)"Gets a collection of all the references which have the specified or an equivalent rule applied to them.
public WorksheetReferenceCollection GetAllReferences(DataValidationRule rule)Parameters
- rule:
DataValidationRule
Returns any
Remove(DataValidationRule)
Section titled "Remove(DataValidationRule)"Removes the specified rule from the .
public bool Remove(DataValidationRule rule)Parameters
- rule:
DataValidationRule
Returns any
Remove(WorksheetCell)
Section titled "Remove(WorksheetCell)"Removes the data validation rule form the cell if one is applied.
public bool Remove(WorksheetCell cell)Parameters
- cell:
WorksheetCell
Returns any
Remove(WorksheetReferenceCollection)
Section titled "Remove(WorksheetReferenceCollection)"Removes the data validation rule form all cells in the specified collection.
public bool Remove(WorksheetReferenceCollection references)Parameters
- references:
WorksheetReferenceCollection
Returns any
Remove(WorksheetRegion)
Section titled "Remove(WorksheetRegion)"Removes the data validation rule form all cells in the specified region.
public bool Remove(WorksheetRegion region)Parameters
- region:
WorksheetRegion
Returns any
TryGetReferences(DataValidationRule, out WorksheetReferenceCollection)
Section titled "TryGetReferences(DataValidationRule, out WorksheetReferenceCollection)"Gets the references which have the specified rule applied to them or null if the rule is not used on the .
public bool TryGetReferences(DataValidationRule rule, out WorksheetReferenceCollection references)Parameters
- rule:
DataValidationRule - references:
WorksheetReferenceCollection