Skip to content

Copy Activity

The Copy activity enables users to duplicate data from a specified range within an Excel file. It supports copying data within the same workbook or between different Excel workbooks, providing flexibility in data transfer operations.

Field Description Requirement
Excel Name The reference name of an already opened or created Excel file. Required
Sheet Name The name of the sheet within the Excel file to work with. If not specified, the first sheet is used by default. Optional
Sheet Index The index of the sheet within the Excel file to work with. If not specified, the first sheet is used by default. Optional
Destination The starting cell (e.g., D1) where the copied data will be written in the destination Excel file. Optional
Source Excel The reference name of the Excel file from which data will be copied. Optional
Source Sheet The name of the sheet within the source Excel file from which data will be retrieved. Optional
Range The range of cells (e.g., A1:B5) to be copied from the source. Optional
Shift Specifies how the dataset is copied to the Excel file, particularly when overwriting existing data. Required
Copy as Value When selected, copies only the values of cells, ignoring any formulas. This is useful for preserving calculated results. Optional

Action Types & Examples

Shift Options

  • Format: string

  • Example Result: NONE

  • Format: string

  • Example Result: RIGHT

  • Format: string

  • Example Result: DOWN

Implementation Examples

Field Setup

  • Excel Name: ${newExcel}
  • Sheet Name: Sheet1
  • Sheet Index: 5
  • Destination: D1
  • Source Excel: ${newExcel}
  • Range: A1:B5
  • Shift: NONE
  • Copy as Value: true

Execution Parameters

Technical Notes

Sheet name fields do not have to be filled if the first sheet of the Excel file will be copied. Otherwise, it must be filled.

If there are two separate Excel files and a copy operation is performed between them, the Sheet Name, Source Sheet, and Source Excel fields must be filled.

The Copy as Value option is crucial when dealing with cells containing formulas. Selecting this option ensures that only the calculated results are copied, preventing potential data loss or incorrect values if formulas are not properly transferred.