## ValidationCollection class

Represents data validation collection.

```javascript
class ValidationCollection implements Iterable<Validation>;
```


## Methods

| Method | Description |
| --- | --- |
| [get(number)](#get-number-)| Gets the [Validation](../validation/) element at the specified index. |
| [add(CellArea)](#add-cellarea-)| Adds a data validation to the collection. |
| [removeACell(number, number)](#removeACell-number-number-)| Removes all validation setting on the cell. |
| [removeArea(CellArea)](#removeArea-cellarea-)| Removes all validation setting on the range.. |
| [getValidationInCell(number, number)](#getValidationInCell-number-number-)| Gets the validation applied to given cell. |
| [getCount()](#getCount--)| <b>@deprecated.</b> Please use the 'count' property instead. Gets the number of elements contained in. |
| [isNull()](#isNull--)| Checks whether the implementation object is null. |

## \[Symbol.iterator\](): Iterator\<Validation\>

Returns an iterator over the items in the collection. Enables use of `for...of`, spread syntax, and `Array.from()`.



### get(number) {#get-number-}

Gets the [Validation](../validation/) element at the specified index.

```javascript
get(index: number) : Validation;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| index | number | The zero based index of the element. |

**Returns**

The element at the specified index.

### add(CellArea) {#add-cellarea-}

Adds a data validation to the collection.

```javascript
add(ca: CellArea) : number;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| ca | [CellArea](../cellarea/) | The area contains this validation. |

**Returns**

[Validation](../validation/) object index.

### removeACell(number, number) {#removeACell-number-number-}

Removes all validation setting on the cell.

```javascript
removeACell(row: number, column: number) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| row | number | The row index of the cell. |
| column | number | The column index of the cell. |

### removeArea(CellArea) {#removeArea-cellarea-}

Removes all validation setting on the range..

```javascript
removeArea(ca: CellArea) : void;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| ca | [CellArea](../cellarea/) | The range which contains the validations setting. |

### getValidationInCell(number, number) {#getValidationInCell-number-number-}

Gets the validation applied to given cell.

```javascript
getValidationInCell(row: number, column: number) : Validation;
```

**Parameters:**
| Parameter | Type | Description |
| --- | --- | --- |
| row | number | The row index. |
| column | number | The column index. |

**Returns**

Returns a [Validation](../validation/) object or null if there is no validation for given cell

### getCount() {#getCount--}

<b>@deprecated.</b> Please use the 'count' property instead. Gets the number of elements contained in.

```javascript
getCount() : number;
```


### isNull() {#isNull--}

Checks whether the implementation object is null.

```javascript
isNull() : boolean;
```