Skip to main content

Copy Paste Range

UiPath.GSuite.Activities.CopyPasteRangeConnections

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.

Scopes​

This activity requires the following scopes:

OR

Project compatibility​

Windows | Cross-platform

Configuration​

  • Add new connection - You must connect to Google Sheets to use this activity.

  • Spreadsheet - The spreadsheet where the autocomplete will be performed. This property supports String variables and string formatted values.

  • Spreadsheet sample - Select a file with the same range and column structure as the variable file. This field becomes visible when you select the Use spreadsheet template option.

  • From Sheet Name - The name of the sheet that you want to copy data from. This property supports String variables and string formatted values.

  • 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.

  • To Sheet Name - The name of the sheet that you want to paste data into. This property supports String variables and string formatted values.

  • Starting Cell - The starting cell where you want to paste the copied data. This property supports String variables and string formatted values. Enter your range in A1-style notation. The default value is C3.

Input​

  • PasteOrientation - The orientation used when pasting data. Select one of the following options: Normal and Transpose. The default is Normal.
    • The Transpose option indicates that the copied rows will paste as columns and the copied columns paste as rows.
  • PasteType - The format used to control how copied data is pasted. Select one of 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 Formatting: Pastes the conditional formatting only.