Activities
latest
false
Banner background image
Productivity Activities
Last updated May 22, 2024

Copy Paste Range

UiPath.GSuite.Activities.AutoFillRange

Description

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.

Project compatibility

Windows - Legacy | Windows

Configuration

Properties

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.
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. This field supports Boolean values.
  • 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.