WriteRange

Writes a data table to the indicated range from the selected spreadsheet.

Namespace: UiPath.Gsuite.Activities.API

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

Syntax

void WriteRange(
	ISpreadsheet spreadsheet,
	IRange range,
	DataTable data,
	bool hasHeaders = true,
	RangeWriteMode writeMode = RangeWriteMode.Overwrite,
	int insertRowPosition = 0
)

Parameters

spreadsheet ISpreadsheet

The Google spreadsheet file to use.

range IRange

Indicate in which range to write or append the data.

data DataTable (Optional)

The DataTable data that will be written in the spreadsheet.

writeMode RangeWriteMode (Optional)

Specifies how to add the data to the specified range.

insertRowPosition Int32 (Optional)

The row index position where the activity inserts the data. Rows starts from 0.