Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, CLI, Studio and browser tools 573 stars PSWriteOfficePowerShell module 165 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/

API Reference

Class

ExcelRangeDataValidationBuilder

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source ExcelRangeDataValidationBuilder.cs:18
Modifiers sealed

Fluent data validation builder for an ExcelRange.

Inheritance

  • Object
  • ExcelRangeDataValidationBuilder

Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by 2

Methods

public ExcelRange Clear() #
ExcelRangeDataValidationBuilder.cs:126
Returns: ExcelRange

Removes data validations that overlap the range.

public ExcelRange CustomFormula(String formula, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:110
Returns: ExcelRange

Applies custom formula validation.

Parameters

formula System.String requiredposition: 0
allowBlank System.Boolean = true optionalposition: 1
errorTitle System.String? = null optionalposition: 2
errorMessage System.String? = null optionalposition: 3
public ExcelRange Date(ExcelDataValidationOperator operator, DateTime formula1, DateTime? formula2 = null, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:79
Returns: ExcelRange

Applies date validation.

Parameters

operator OfficeIMO.Excel.ExcelDataValidationOperator requiredposition: 0
formula1 System.DateTime requiredposition: 1
formula2 System.DateTime? = null optionalposition: 2
allowBlank System.Boolean = true optionalposition: 3
errorTitle System.String? = null optionalposition: 4
errorMessage System.String? = null optionalposition: 5
public ExcelRange DateBetween(DateTime minimum, DateTime maximum, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:87
Returns: ExcelRange

Applies date validation between two dates.

Parameters

minimum System.DateTime requiredposition: 0
maximum System.DateTime requiredposition: 1
allowBlank System.Boolean = true optionalposition: 2
errorTitle System.String? = null optionalposition: 3
errorMessage System.String? = null optionalposition: 4
public ExcelRange Decimal(ExcelDataValidationOperator operator, Double formula1, Double? formula2 = null, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:64
Returns: ExcelRange

Applies decimal-number validation.

Parameters

operator OfficeIMO.Excel.ExcelDataValidationOperator requiredposition: 0
formula1 System.Double requiredposition: 1
formula2 System.Double? = null optionalposition: 2
allowBlank System.Boolean = true optionalposition: 3
errorTitle System.String? = null optionalposition: 4
errorMessage System.String? = null optionalposition: 5
public ExcelRange DecimalBetween(Double minimum, Double maximum, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:72
Returns: ExcelRange

Applies decimal-number validation between two values.

Parameters

minimum System.Double requiredposition: 0
maximum System.Double requiredposition: 1
allowBlank System.Boolean = true optionalposition: 2
errorTitle System.String? = null optionalposition: 3
errorMessage System.String? = null optionalposition: 4
List 2 overloads
public ExcelRange List(params String[] items) #
ExcelRangeDataValidationBuilder.cs:18
Returns: ExcelRange

Applies list validation from inline items.

Parameters

items System.String[] requiredposition: 0
public ExcelRange List(IEnumerable<String> items, Boolean allowBlank = true) #
ExcelRangeDataValidationBuilder.cs:25
Returns: ExcelRange

Applies list validation from inline items.

Parameters

items System.Collections.Generic.IEnumerable<System.String> requiredposition: 0
allowBlank System.Boolean = true optionalposition: 1
public ExcelRange ListNamedRange(String namedRange, Boolean allowBlank = true) #
ExcelRangeDataValidationBuilder.cs:33
Returns: ExcelRange

Applies list validation using a workbook or sheet-local named range.

Parameters

namedRange System.String requiredposition: 0
allowBlank System.Boolean = true optionalposition: 1
public ExcelRange ListRange(String sourceA1Range, String? sourceSheetName = null, Boolean allowBlank = true) #
ExcelRangeDataValidationBuilder.cs:41
Returns: ExcelRange

Applies list validation using a worksheet range.

Parameters

sourceA1Range System.String requiredposition: 0
sourceSheetName System.String? = null optionalposition: 1
allowBlank System.Boolean = true optionalposition: 2
public ExcelRange Messages(ExcelDataValidationMessageOptions options) #
ExcelRangeDataValidationBuilder.cs:118
Returns: ExcelRange

Applies prompt and error message metadata to validations that overlap the range.

Parameters

options OfficeIMO.Excel.ExcelDataValidationMessageOptions requiredposition: 0
public ExcelRange TextLength(ExcelDataValidationOperator operator, Int32 formula1, Int32? formula2 = null, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:102
Returns: ExcelRange

Applies text-length validation.

Parameters

operator OfficeIMO.Excel.ExcelDataValidationOperator requiredposition: 0
formula1 System.Int32 requiredposition: 1
formula2 System.Int32? = null optionalposition: 2
allowBlank System.Boolean = true optionalposition: 3
errorTitle System.String? = null optionalposition: 4
errorMessage System.String? = null optionalposition: 5
public ExcelRange Time(ExcelDataValidationOperator operator, TimeSpan formula1, TimeSpan? formula2 = null, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:94
Returns: ExcelRange

Applies time validation.

Parameters

operator OfficeIMO.Excel.ExcelDataValidationOperator requiredposition: 0
formula1 System.TimeSpan requiredposition: 1
formula2 System.TimeSpan? = null optionalposition: 2
allowBlank System.Boolean = true optionalposition: 3
errorTitle System.String? = null optionalposition: 4
errorMessage System.String? = null optionalposition: 5
public ExcelRange WholeNumber(ExcelDataValidationOperator operator, Int32 formula1, Int32? formula2 = null, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:49
Returns: ExcelRange

Applies whole-number validation.

Parameters

operator OfficeIMO.Excel.ExcelDataValidationOperator requiredposition: 0
formula1 System.Int32 requiredposition: 1
formula2 System.Int32? = null optionalposition: 2
allowBlank System.Boolean = true optionalposition: 3
errorTitle System.String? = null optionalposition: 4
errorMessage System.String? = null optionalposition: 5
public ExcelRange WholeNumberBetween(Int32 minimum, Int32 maximum, Boolean allowBlank = true, String? errorTitle = null, String? errorMessage = null) #
ExcelRangeDataValidationBuilder.cs:57
Returns: ExcelRange

Applies whole-number validation between two values.

Parameters

minimum System.Int32 requiredposition: 0
maximum System.Int32 requiredposition: 1
allowBlank System.Boolean = true optionalposition: 2
errorTitle System.String? = null optionalposition: 3
errorMessage System.String? = null optionalposition: 4