Options

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