Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Read Range

UiPath.GSuite.Activities.ReadRange

Description

Reads the contents of a range in a Google spreadsheet and converts it to a DataTable.

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity
  • Spreadsheet - A reference to a Google Spreadsheet where a certain range is to be read. Typically obtained via the Use Google Spreadsheet activity. This property supports IGoogleSheetTarget variables.
  • SheetName - The name of the sheet that includes the range you want to read. This property supports String variables and string formatted values. The default value is "Sheet1".
  • Range - The address of the first cell that you want to read, for example Sheet3!B3:D10. This property supports String variables and string formatted values. The default value is "A1". All cells that contain content in the row specified are read.
  • Has headers - If selected, the first row from the range will be defined as column header for the data table. If not selected, the headers have a default value of Column n, where n is the column number. This option is selected by default.
  • Save to - The variable into which the read value is saved, if you want to use the data table in other activities in the automation.
Properties Panel

Common

  • ContinueOnError - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
  • DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

  • Spreadsheet - See Spreadsheet in the body of the activity.
  • Range - See Range in the body of the activity.
  • SheetName - See Sheet in the body of the activity.
  • SpreadsheetID - The ID of the spreadsheet file to use. This property supports String variables and string formatted values.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

Options

  • IncludeHeaders - See Has headers in the body of the activity.

Output

  • Result - See Save to in the body of the activity.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.