Page History

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 `DataValidation` objects. To apply a `DataValidation` object to a cell or group of cells, use Area.SetDataValidation or Range.SetDataValidation.

*.

{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xlw = new ExcelApplication();
          Workbook wb = xlw.Create();

          //--- Create a data validation rule:
          DataValidation dv = wb.CreateDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.Between,
               "=1", "=100");
          String formula = "Sheet1!A2:F33 Sheet2!A5:D15";

          //--- Apply the rule to a Range:
          wb.CreateRange(formula).SetDataValidation(dv);

{code}
{code:vb.net

|title=vb.net

}

          Dim xlw As New ExcelApplication()
          Dim wb As Workbook = xlw.Create()

          '--- Create a data validation rule:
          Dim dv As DataValidation = wb.CreateDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.Between, _
               "=1", "=100")
          Dim formula As String = "Sheet1!A2:F33 Sheet2!A5:D15"

          '--- Apply the rule to a Range:
          wb.CreateRange(formula).SetDataValidation(dv)

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

...

AllowedType

...

{code}

{example}
{properties}
||Name||Description||
|[AllowedType|DataValidation.AllowedType]|{excerpt-include:DataValidation.AllowedType

...

Comparison

|nopanel=true}|
|[Comparison|DataValidation.Comparison]|{excerpt-include

...

:DataValidation.Comparison

...

ErrorAlert

|nopanel=true}|
|[ErrorAlert|DataValidation.ErrorAlert]|{excerpt-include

...

:DataValidation.ErrorAlert

...

ErrorAlertStyle

|nopanel=true}|
|[ErrorAlertStyle|DataValidation.ErrorAlertStyle]|{excerpt-include

...

:DataValidation.ErrorAlertStyle

...

ErrorAlertTitle

|nopanel=true}|
|[ErrorAlertTitle|DataValidation.ErrorAlertTitle]|{excerpt-include

...

:DataValidation.ErrorAlertTitle

...

IgnoreBlanks

|nopanel=true}|
|[IgnoreBlanks|DataValidation.IgnoreBlanks]|{excerpt-include

...

:DataValidation.IgnoreBlanks

...

InputMessage

|nopanel=true}|
|[InputMessage|DataValidation.InputMessage]|{excerpt-include

...

:DataValidation.InputMessage

...

MinimumValue

|nopanel=true}|
|[MinimumValue|DataValidation.MinimumValue]|{excerpt-include

...

:DataValidation.MinimumValue

...

MaximumValue

|nopanel=true}|
|[MaximumValue|DataValidation.MaximumValue]|{excerpt-include

...

:DataValidation.MaximumValue

...

ShowErrorAlert

|nopanel=true}|
|[ShowErrorAlert|DataValidation.ShowErrorAlert]|{excerpt-include

...

:DataValidation.ShowErrorAlert

...

ShowInputMessage

|nopanel=true}|
|[ShowInputMessage|DataValidation.ShowInputMessage]|{excerpt-include

...

:DataValidation.ShowInputMessage

...

Title

|nopanel=true}|
|[Title|DataValidation.Title]|{excerpt-include

...

:DataValidation.Title

...

UseListDropdown

|nopanel=true}|
|[UseListDropdown|DataValidation.UseListDropdown]|{excerpt-include

...

:DataValidation.UseListDropdown

...

Methods

...

Name

...

Description

...

Clear()

...

|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

...

ComparisonType

...

=true}|
{classes}
||Name||Description||
|[ComparisonType|DataValidation.ComparisonType]|{excerpt-include:DataValidation.ComparisonType

...

ErrorAlertStyleType

|nopanel=true}|
|[ErrorAlertStyleType|DataValidation.ErrorAlertStyleType]|{excerpt-include

...

:DataValidation.ErrorAlertStyleType

...

ValidationType

|nopanel=true}|
|[ValidationType|DataValidation.ValidationType]|{excerpt-include

...

:DataValidation.ValidationType

...

|nopanel=true}|

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key