UiPath Integrations

The UiPath Integrations Guide

Welcome to the UiPath Integrations guide. You will find comprehensive guides and documentation to help you start working with UiPath Integrations, as well as support if you get stuck.

In order to download the solutions mentioned here please visit the official UiPath Go! Marketplace here.

*Note that only integrations built in-house at UiPath are detailed below. For a complete list of UiPath's technology partners, see here.

Copy Sheet

Overview

The Copy Sheet activity uses the Microsoft Graph GetRange, AddWorkbookWorksheet, and UpdateRange APIs to copy an existing worksheet (CopySheet) in a specified workbook (CopyWorkbook) and then paste it as a new worksheet (PasteSheet) into the same or a different workbook (PasteWorkbook). The copied worksheet is pasted at the end of the existing worksheets in the workbook.

How it works

The following steps and message sequence diagram is an example how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

  1. Complete the Setup steps.
  2. Add the Microsoft Office 365 Scope activity to your project.
  3. Add an activity or run an external process that outputs a DriveItem object (e.g., Find Files and Folders, Create Workbook, Copy Item).
  4. Add the Copy Sheet activity inside the Microsoft Teams Scope activity.
  5. Enter values for the Input properties.
  6. Run the activity.

Properties

The values for the following properties are specified when adding this activity to your project in UiPath Studio.

Common

DisplayName

The display name of the activity.

Attributes
Details

Type

String

Required

Yes

Default value

Copy Sheet

Allowed values

Enter a String or String variable.

Notes

N/A


Input

CopySheet

The name of the sheet that you want to copy.

Attributes
Details

Type

String

Required

Yes

Default value

"Sheet1"

Allowed values

Enter a String or String variable.

Notes

N/A


CopyWorkbook

The workbook that contains the sheet that you want to copy (CopySheet).

Attributes
Details

Type

DriveItem

Required

Yes

Default value

Empty

Allowed values

Enter a DriveItem variable.

Notes

  • Use the output property variable from either
    the Find Files and Folders (First or Results) or Create Workbook (Workbook) activities (see example image below).
  • When using the Results output property from the Find Files and Folders activity, specify the item in the array that you want to use (e.g., myWorkbooks(0))

PasteSheet

The name applied to the sheet when its pasted into the specified workbook.

Attributes
Details

Type

String

Required

No

Default value

Empty

Allowed values

Enter a String or String variable.

Notes

  • If you don't specify a value, the PasteSheet name will be the same as the CopySheet name.
  • If you paste the PasteSheet inside the same workbook as the CopyWorkbook, a "n" is added at the end of the sheet name (e.g., Sheet1n).
  • If the PasteSheet name is the same as an existing sheet, the existing sheet content will be overwritten by the CopySheet data (i.e., a new sheet is not created with the PasteSheet name and "n" appended to the end).

PasteWorkbook

The workbook that you want to paste the copied sheet into.

Attributes
Details

Type

DriveItem

Required

Yes

Default value

Empty

Allowed values

Enter a DriveItem variable.

Notes

  • Use the output property variable from either
    the Find Files and Folders (First or Results) or Create Workbook (Workbook) activities (see example image below).
  • When using the Results output property from the Find Files and Folders activity, specify the item in the array that you want to use (e.g., myWorkbooks(0))
  • You can use the same variable as the CopyWorkbook if you want to copy/paste the sheet into the same workbook.

Misc

Private

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

Attributes
Details

Type

Checkbox

Required

No

Default value

Not Selected

Allowed values

Selected or Not Selected

Notes

N/A


Example

The following image shows an example of the activity dependency relationship and input/output property values.

For step-by-step instructions and examples, see the Quickstart guides.

Updated 3 months ago


Copy Sheet


Suggested Edits are limited on API Reference Pages

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