Class DataValidationCollection

Inheritance

System.Object

DataValidationCollection

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class DataValidationCollection : IEnumerable<DataValidation>

Properties

Count

Declaration

public int Count { get; }

Property Value

Type	Description
System.Int32

Methods

Add(DataValidation)

Declaration

public void Add(DataValidation validation)

Parameters

Type	Name	Description
DataValidation	validation

Add(String, DataValidationType, DataValidationOperator, String[])

Declaration

public DataValidation Add(string range, DataValidationType type, DataValidationOperator operator, params string[] formula)

Parameters

Type	Name	Description
System.String	range
DataValidationType	type
DataValidationOperator	operator
System.String[]	formula

Returns

Type	Description
DataValidation

AddCustom(String, String)

Declaration

public DataValidation AddCustom(string range, string formula)

Parameters

Type	Name	Description
System.String	range
System.String	formula

Returns

Type	Description
DataValidation

AddDate(String, DataValidationOperator, DateTime[])

Declaration

public DataValidation AddDate(string range, DataValidationOperator operator, params DateTime[] dates)

Parameters

Type	Name	Description
System.String	range
DataValidationOperator	operator
DateTime[]	dates

Returns

Type	Description
DataValidation

AddDecimal(String, DataValidationOperator, Double[])

Declaration

public DataValidation AddDecimal(string range, DataValidationOperator operator, params double[] numbers)

Parameters

Type	Name	Description
System.String	range
DataValidationOperator	operator
System.Double[]	numbers

Returns

Type	Description
DataValidation

AddList(String, String)

Declaration

public DataValidation AddList(string range, string formula)

Parameters

Type	Name	Description
System.String	range
System.String	formula

Returns

Type	Description
DataValidation

AddTextLength(String, DataValidationOperator, Int32[])

Declaration

public DataValidation AddTextLength(string range, DataValidationOperator operator, params int[] numbers)

Parameters

Type	Name	Description
System.String	range
DataValidationOperator	operator
System.Int32[]	numbers

Returns

Type	Description
DataValidation

AddTime(String, DataValidationOperator, TimeSpan[])

Declaration

public DataValidation AddTime(string range, DataValidationOperator operator, params TimeSpan[] times)

Parameters

Type	Name	Description
System.String	range
DataValidationOperator	operator
TimeSpan[]	times

Returns

Type	Description
DataValidation

AddWholeNumber(String, DataValidationOperator, Int32[])

Declaration

public DataValidation AddWholeNumber(string range, DataValidationOperator operator, params int[] numbers)

Parameters

Type	Name	Description
System.String	range
DataValidationOperator	operator
System.Int32[]	numbers

Returns

Type	Description
DataValidation

Get(String)

Declaration

public DataValidation Get(string label)

Parameters

Type	Name	Description
System.String	label

Returns

Type	Description
DataValidation

GetEnumerator()

Declaration

public IEnumerator<DataValidation> GetEnumerator()

Returns

Type	Description
IEnumerator<DataValidation>