Skip to content

Copy/Remove Sheet Activity

The Copy/Remove Sheet activity enables users to manage sheets within an Excel file. It facilitates copying data from a specified range to a new sheet or removing an existing sheet.

Field Description Requirement
Excel name The reference name of an already opened or created Excel file. Required
Sheet name The name of the sheet to operate on. If not specified, the activity defaults to the first sheet. Optional
Action The desired operation to perform on the sheet. Required
New sheet name The name for the new sheet when performing a copy action. Optional

Action Types & Examples

COPY

  • Format: string
  • Example Result: "COPY"

REMOVE

  • Format: string
  • Example Result: "REMOVE"

Implementation Examples

Field Setup - Excel name: ${newExcel} - Sheet name: Sheet1 - Action: COPY - New sheet name: NewSheet

Execution Parameters - Excel name: ${newExcel} - Sheet name: Sheet1 - Action: REMOVE

Technical Notes

When the Action property is set to REMOVE, the Sheet name field becomes mandatory and must be configured for successful execution.