ReadCell

Reads the contents of the specified cell.

Namespace: UiPath.Gsuite.Activities.API

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

Syntax

Object ReadCell(
	ISpreadsheet spreadsheet,
	IRange range,
	string cell,
	ValuesType cellValueType = ValuesType.Values
)

Parameters

spreadsheet ISpreadsheet

The Google spreadsheet file to use.

range IRange

The sheet or named range where the cell is located, e.g., Sheet1. If it is a named range, it will read the first cell of the range.

cell String

The cell to read from, e.g., A1. Leave empty for named range.

cellValueType ValuesType

(Optional) Specifies the type of value to be read.

Return value

Object - The contents of the cell.