Skip to main content

Auto Fill Range

UiPath.GSuite.Activities.AutoFillRange

Description

Fulfills the auto-fill functionality from the Google Sheets user interface.

note

This classic activity is in maintenance mode. Instead, use the modern equivalent, the Auto Fill Range activity.

Scopes

This activity requires the following scopes:

OR

Project compatibility

Windows - Legacy | Windows

Configuration

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

  • FillLength - The number of rows that you want to auto-fill. This property supports Int32 variables and Int32 formatted values.
  • RuleRange - Specifies the range of cells that you want to auto-fill. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".
  • SheetName - The name of the sheet that you want to auto-fill rows. This property supports String variables and string formatted values. The default value is "New Sheet".
  • SpreadSheetID - The ID of the spreadsheet that contains the sheet you want to auto-fill rows. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous Find Files And Folders or Copy File activity.

Options

  • Direction - Specifies the direction you want auto-fill. Select one of the following options: UP, DOWN, LEFT, or RIGHT.

Misc

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