UiPath Activities

The UiPath Activities Guide

Copy Paste Range

UiPath.GSuite.Activities.AutoFillRange

Copies and pastes a range of specified cells into a specified sheet. You can copy from sheet and paste into a different one, or copy and paste within the same sheet.

Properties

Common

  • DisplayName - The display name of the activity.

Destination

  • StartingCell - The cell where you want to begin pasting your copied data. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is "C3".
  • ToSheetName - The name of the sheet that you want to paste data into. This property supports String variables and string formatted values.

Input

  • SpreadSheetID - The ID of the spreadsheet that contains the sheet you want to paste data into. 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

  • PasteOrientation - The orientation of the paste date. There are two options: NORMAL and TRANSPOSE.
    • The TRANSPOSE option indicates that the copied rows will paste as columns and the copied columns paste as rows.
  • PasteType - The format to paste the copied data. Select from the following options:
    • PASTE_NORMAL: Paste values, formulas, formats and merges.
    • PASTE_VALUES: Paste values only, without formulas, formats and merges.
    • PASTE_FORMAT: Pastes format and data validation only.
    • PASTE_NO_BORDERS: Pastes values, formulas, formats and merges, all without borders.
    • PASTE_FORMULA: Pastes the formula only.
    • PASTE_DATA_VALIDATION: Pastes data validation only.
    • PASTE_CONDITIONAL_FORMATING - Pastes the conditional formatting only.

Source

  • FromSheetName - The name of the sheet that you want to copy data from. This property supports String variables and string formatted values. The default value is "Sheet1".
  • Range - Specifies the range of cells that you want to copy. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".
    • For example, if you have data in cells A1:C4, and you enter "A1:B3" as your Range, the data in cells A1:B3 is copied and the data in cells A4, B4, and C1:C4 remains.

Misc

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

Updated 13 days ago


Copy Paste Range


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.