# GoogleSheetsSetDataValidationRequest

Applies one validation rule to an entire worksheet range without materializing every target cell.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsRequest.cs:87](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L87)

**Base**

`GoogleSheetsRequest`

**Modifiers**

sealed

Applies one validation rule to an entire worksheet range without materializing every target cell.

## Inheritance

- [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)
- GoogleSheetsSetDataValidationRequest

Filter members 

Show inherited

## Constructors

`public GoogleSheetsSetDataValidationRequest()` [#](#constructor-ctor)

[GoogleSheetsRequest.cs:87](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L87)

Creates a range validation request.

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public string SheetName { get; set; }` [#](#property-sheetname)

[GoogleSheetsRequest.cs:87](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L87)

Gets or sets the target worksheet.

`public string A1Range { get; set; }` [#](#property-a1range)

[GoogleSheetsRequest.cs:89](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L89)

Gets or sets the range in A1 notation.

`public int StartRowIndex { get; set; }` [#](#property-startrowindex)

[GoogleSheetsRequest.cs:91](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L91)

Gets or sets the inclusive zero-based first row.

`public int EndRowIndexExclusive { get; set; }` [#](#property-endrowindexexclusive)

[GoogleSheetsRequest.cs:93](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L93)

Gets or sets the exclusive zero-based ending row.

`public int StartColumnIndex { get; set; }` [#](#property-startcolumnindex)

[GoogleSheetsRequest.cs:95](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L95)

Gets or sets the inclusive zero-based first column.

`public int EndColumnIndexExclusive { get; set; }` [#](#property-endcolumnindexexclusive)

[GoogleSheetsRequest.cs:97](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L97)

Gets or sets the exclusive zero-based ending column.

`public GoogleSheetsDataValidationRule Rule { get; set; }` [#](#property-rule)

[GoogleSheetsRequest.cs:99](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L99)

Gets or sets the validation rule applied across the range.

## Inherited Properties

`public string Kind { get; }` [#](#property-kind)

[GoogleSheetsRequest.cs:24](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L24)

Inherited from [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)

<!-- PowerForge markdown artifact sha256:0D8B4FFA88CCA9F4FF10A0CE822D8A7083F3660C6A73FAE40D5F778A2097D92D -->
