Duplicate Sheet

UiPath.Excel.Activities.Business.DuplicateSheetX

Creates a copy of a specified sheet in an Excel file. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

• Sheet to duplicate - Click Plus on the right side of the field and then, from the menu, select the file and then the sheet to duplicate. If you select Indicate in Excel, you can select any cell or range from the sheet you want to duplicate directly from the file. Alternatively, you can select Custom Input to enter the sheet name manually, or Open in Advanced Editor to enter a VB expression.

• Rename to - Click Plus on the right side of the field and then, from the menu, select one of the available options to enter the name of the new sheet:

  • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select a cell in an Excel file or a field in a selected Outlook email.
  • Use Saved Value - Select a value that you previously saved for later use in the project.
  • Text - Enter a name in the Text Builder.
  • Ask when run - Prompt for a name when the project is executed.

  • Open in Advanced Editor - Enter a VB expression.

    The default name is New Sheet.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• See the options in the body of the activity.

Misc

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