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.

Signature

	C#
	C#

 public sealed class DataValidation
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public NotInheritable Class DataValidation
{signature}
{remarks}In Microsoft

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

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

.

Example

Code Block

	csharp
	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:

Code Block

	vb.net

|title=


	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)

{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|nopanel=true}| {methods} ||Name||Description|| |[Clear()|DataValidation.Clear()]|{excerpt-include:DataValidation.Clear()|nopanel=true}| |[SetAllowedType(ValidationType, ComparisonType, Object)|

Properties

Name

Description

AllowedType

Excerpt Include

	DataValidation.AllowedType
	DataValidation.AllowedType
nopanel	true

Comparison

Excerpt Include

	DataValidation.Comparison
	DataValidation.Comparison
nopanel	true

ErrorAlert

Excerpt Include

	DataValidation.ErrorAlert
	DataValidation.ErrorAlert
nopanel	true

ErrorAlertStyle

Excerpt Include

	DataValidation.ErrorAlertStyle
	DataValidation.ErrorAlertStyle
nopanel	true

ErrorAlertTitle

Excerpt Include

	DataValidation.ErrorAlertTitle
	DataValidation.ErrorAlertTitle
nopanel	true

IgnoreBlanks

Excerpt Include

	DataValidation.IgnoreBlanks
	DataValidation.IgnoreBlanks
nopanel	true

InputMessage

Excerpt Include

	DataValidation.InputMessage
	DataValidation.InputMessage
nopanel	true

MinimumValue

Excerpt Include

	DataValidation.MinimumValue
	DataValidation.MinimumValue
nopanel	true

MaximumValue

Excerpt Include

	DataValidation.MaximumValue
	DataValidation.MaximumValue
nopanel	true

ShowErrorAlert

Excerpt Include

	DataValidation.ShowErrorAlert
	DataValidation.ShowErrorAlert
nopanel	true

ShowInputMessage

Excerpt Include

	DataValidation.ShowInputMessage
	DataValidation.ShowInputMessage
nopanel	true

Title

Excerpt Include

	DataValidation.Title
	DataValidation.Title
nopanel	true

UseListDropdown

Excerpt Include

	DataValidation.UseListDropdown
	DataValidation.UseListDropdown
nopanel	true

Methods

Name

Description

Clear()

Excerpt Include

	DataValidation.Clear()
	DataValidation.Clear()
nopanel	true

SetAllowedType(ValidationType, ComparisonType, Object)

Excerpt Include

	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

DataValidation.ComparisonType,

...

Object)

...


	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

DataValidation.ComparisonType,

...

Object)

...

nopanel

...

	true

SetAllowedType(ValidationType,

...

ComparisonType,

...

Object,

...

Object)

...

Excerpt Include

	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

DataValidation.ComparisonType,

...

Object,

...

Object)

...


	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

DataValidation.ComparisonType,

...

Object,

...

Object)

...

nopanel

...

	true

SetAllowedType(ValidationType,

...

Object)

...

Excerpt Include

	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

Object)

...


	DataValidation.SetAllowedType(DataValidation.ValidationType,

...

Object)

...

nopanel

...

	true

Classes

Name

Description

ComparisonType

Excerpt Include

	DataValidation.ComparisonType
	DataValidation.ComparisonType
nopanel	true

ErrorAlertStyleType

Excerpt Include

	DataValidation.ErrorAlertStyleType
	DataValidation.ErrorAlertStyleType
nopanel	true

ValidationType

Excerpt Include

	DataValidation.ValidationType
	DataValidation.ValidationType
nopanel	true

Space Shortcuts

Page tree

Versions Compared

Old Version 5

New Version Current

Key