# Options

> Indicates how to delete column data

## ColumnDelete

Indicates how to delete column data

**Namespace**: UiPath.Gsuite.Activities.API

**Assembly**: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

### Syntax

```
public enum ColumnDeleteMode
```

### Options

| Option | Value | Description |
| --- | --- | --- |
| Clear | 0 | Clear column values |
| Delete | 1 | Delete entire column |

## ConflictBehavior

What to be the expected behavior when an item with the same name already exists in the destination.

**Namespace**: UiPath.Gsuite.Activities.API

**Assembly**: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

### Syntax

```
public enum ConflictBehavior
```

### Options

| Option | Value | Description |
| --- | --- | --- |
| Replace | 0 | Replaces the existing item |
| Fail | 1 | If another item with the same name exists at the same location, fail the request |
| Rename | 2 | Renames the new item to have an unique name |
| AddSeparate | 3 | Adds the item without renaming it, even if one with the same name already exists |
| UseExisting | 4 | Return the existing item |

## RangeWriteMode

Indicates how to add the DataTable to the indicated range.

**Namespace**: UiPath.Gsuite.Activities.API

**Assembly**: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

### Syntax

```
public enum RangeWriteMode
```

### Options

| Option | Value | Description |
| --- | --- | --- |
| Overwrite | 0 | Overwrite any previous data that exists |
| Append | 1 | Append values to the bottom of the range |
| AppendRight | 2 | Append values to the right of the range |
| Insert | 3 | Insert values at a chosen row index of the range |
| InsertRight | 4 | Insert values at a chosen column index of the range |

## RangeDeleteMode

Indicates how to delete a range.

**Namespace**: UiPath.Gsuite.Activities.API

**Assembly**: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

### Options

| Option name | Value | Description |
| --- | --- | --- |
| None | 0 | Clear range values such as format, fill, and border. |
| Rows | 1 | Specifies to shift the cells Up |
| Columns | 2 | Specifies to shift the cells Left |

## RowsDeleteMode

Indicates how to delete N rows.

**Namespace**: UiPath.Gsuite.Activities.API

**Assembly**: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

### Syntax

```
public enum RowsDeleteMode
```

### Options

| Option | Value | Description |
| --- | --- | --- |
| Clear | 0 | Clear range values such as format, fill, and border. |
| Delete | 1 | Specifies to shift the cells up. |

## ValuesType

Enum ValuesType

### Syntax

```
public enum ValuesType
```

### Options

| Option | Value | Description |
| --- | --- | --- |
| Values | 0 | The values |
| Formulas | 1 | The formulas |
| Text | 2 | The text |