Description |
---|
Excerpt |
---|
A DataValidation object represents a rule for validating data entered in cells. The rule may be applied to a cell or a set of cells. The Workbook class contains several CreateDataValidation methods for creating |
Signature | C# | C# | |
---|---|---|---|
Wiki Markup | |||
{description}
{excerpt}A [DataValidation|DataValidation] object represents a rule for validating data entered in cells. The rule may be applied to a cell or a set of cells. The [Workbook] class contains several [CreateDataValidation|Workbook.CreateDataValidation] methods for creating {{DataValidation}} objects. To apply a {{DataValidation}} object to a cell or group of cells, use [Area.SetDataValidation|Area.SetDataValidation(DataValidation)] or [Range.SetDataValidation|Range.SetDataValidation(DataValidation)].{excerpt}
{signature:C#}
public sealed class DataValidation
| |||
Signature | |||
{signature}{signature:vb.net | vb.net | }
Public NotInheritable Class DataValidation
| |
Remarks | |||
In Microsoft {signature} {remarks}In Microsoft Excel, data validation rules are created through the *Data Validation* dialog. To open this dialog, open the *Data* menu and select *Validation. | |||
Example | |||
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vb.net | title |
Properties |
---|
...
Name
...
Description
...
...
{code} {example} {properties} ||Name||Description|| |[AllowedType|DataValidation.AllowedType]|{excerpt-include:DataValidation.AllowedType |
...
|nopanel=true}| |[Comparison|DataValidation.Comparison]|{excerpt-include |
...
:DataValidation.Comparison |
...
|nopanel=true}| |[ErrorAlert|DataValidation.ErrorAlert]|{excerpt-include |
...
:DataValidation.ErrorAlert |
...
|nopanel=true}| |[ErrorAlertStyle|DataValidation.ErrorAlertStyle]|{excerpt-include |
...
:DataValidation.ErrorAlertStyle |
...
|nopanel=true}| |[ErrorAlertTitle|DataValidation.ErrorAlertTitle]|{excerpt-include |
...
:DataValidation.ErrorAlertTitle |
...
|nopanel=true}| |[IgnoreBlanks|DataValidation.IgnoreBlanks]|{excerpt-include |
...
:DataValidation.IgnoreBlanks |
...
|nopanel=true}| |[InputMessage|DataValidation.InputMessage]|{excerpt-include |
...
:DataValidation.InputMessage |
...
|nopanel=true}| |[MinimumValue|DataValidation.MinimumValue]|{excerpt-include |
...
:DataValidation.MinimumValue |
...
|nopanel=true}| |[MaximumValue|DataValidation.MaximumValue]|{excerpt-include |
...
:DataValidation.MaximumValue |
...
|nopanel=true}| |[ShowErrorAlert|DataValidation.ShowErrorAlert]|{excerpt-include |
...
:DataValidation.ShowErrorAlert |
...
|nopanel=true}| |[ShowInputMessage|DataValidation.ShowInputMessage]|{excerpt-include |
...
:DataValidation.ShowInputMessage |
...
|nopanel=true}| |[Title|DataValidation.Title]|{excerpt-include |
...
:DataValidation.Title |
...
|nopanel=true}| |[UseListDropdown|DataValidation.UseListDropdown]|{excerpt-include |
...
:DataValidation.UseListDropdown |
...
Methods |
---|
...
Name
...
Description
...
...
|nopanel=true}| {methods} ||Name||Description|| |[Clear()|DataValidation.Clear() |
...
]|{excerpt-include:DataValidation.Clear() |
...
|nopanel |
...
=true}| |[SetAllowedType(ValidationType, ComparisonType, Object) |
...
|DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object) |
...
]|{excerpt-include:DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object) |
...
|nopanel |
...
=true}| |[SetAllowedType(ValidationType, ComparisonType, Object, Object) |
...
|DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object) |
...
]|{excerpt-include:DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object) |
...
|nopanel |
...
=true}| |[SetAllowedType(ValidationType, Object) |
...
|DataValidation.SetAllowedType(DataValidation.ValidationType, Object) |
...
]|{excerpt-include:DataValidation.SetAllowedType(DataValidation.ValidationType, Object) |
...
|nopanel |
...
Classes |
---|
...
Name
...
Description
...
...
=true}| {classes} ||Name||Description|| |[ComparisonType|DataValidation.ComparisonType]|{excerpt-include:DataValidation.ComparisonType |
...
|nopanel=true}| |[ErrorAlertStyleType|DataValidation.ErrorAlertStyleType]|{excerpt-include |
...
:DataValidation.ErrorAlertStyleType |
...
|nopanel=true}| |[ValidationType|DataValidation.ValidationType]|{excerpt-include |
...
:DataValidation.ValidationType |
...
|nopanel=true}| |