XlDataValidationType Enum

Lists the types of data validation.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlDataValidationType

VB.NET

Public Enum XlDataValidationType

Members

Name	Description
None	No value conforms the validation criteria.
Whole	Checks for whole numeric values conforming the given condition.
Decimal	Checks for decimal values conforming the given condition.
List	Checks the values that matches the list or certain values.
Date	Checks for date values conforming the given condition.
Time	Checks for time values conforming the given condition
TextLength	Checks text values which lengths conforms the given condition.
Custom	The data is validated by an arbitrary formula.

Related API Members

The following properties accept/return XlDataValidationType values:

• XlDataValidation.Type

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlDataValidationType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/PageViewAndLayoutActions.cs#L713

validation.Ranges.Add(XlCellRange.FromLTRB(4, 1, 4, 4));
validation.Type = XlDataValidationType.List;
validation.Criteria1 = XlCellRange.FromLTRB(6, 1, 6, 4).AsAbsolute();

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/CS/XLExportExample/Form1.cs#L308

validation.Ranges.Add(XlCellRange.FromLTRB(0, firstDataRowIndex, 0, sheet.CurrentRowIndex - 1));
validation.Type = XlDataValidationType.Custom;
validation.Criteria1 = string.Format("=AND(ISNUMBER(A{0}),LEN(A{0})=5)", firstDataRowIndex + 1);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/PageViewAndLayoutActions.vb#L677

validation.Ranges.Add(XlCellRange.FromLTRB(4, 1, 4, 4))
validation.Type = XlDataValidationType.List
validation.Criteria1 = XlCellRange.FromLTRB(6, 1, 6, 4).AsAbsolute()

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/VB/XLExportExample/Form1.vb#L324

validation.Ranges.Add(XlCellRange.FromLTRB(0, firstDataRowIndex, 0, sheet.CurrentRowIndex - 1))
validation.Type = XlDataValidationType.Custom
validation.Criteria1 = String.Format("=AND(ISNUMBER(A{0}),LEN(A{0})=5)", firstDataRowIndex + 1)