Copy Activity
The Copy activity enables users to duplicate data from a specified range within an Excel file. It facilitates transferring content from a source sheet to a designated destination cell, offering flexibility in how existing data is handled during the copy operation.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name of the Excel file that has already been opened or created. | Required |
| Sheet name | The name of the sheet within the Excel file to operate on. If not specified, the first sheet is used by default. | Optional |
| Destination | The starting cell in the Excel file where the copied data will be written. | Optional |
| Source sheet | The name of the Excel sheet from which data will be retrieved. | Optional |
| Range | The specific range of cells to be copied (e.g., "A1:B5"). | Optional |
| Shift | Specifies how the dataset is copied to the Excel file, particularly concerning existing data. | Required |
| Copy as value | Determines whether the data is copied with its values only (excluding formulas). This is important if the source cells contain formulas and only their results are desired. | Optional |
Action Types & Examples
Activity Execution Status
- Format: boolean
- Example Result:
true
Implementation Examples
Field Setup - Excel name: newExcel - Sheet name: Sheet1 - Destination: D1 - Source sheet: Sheet2 - Range: A1:B5
Execution Parameters - Shift: NONE (Copies the data to the current location, overwriting existing data.) - Shift: RIGHT (Copies the data to the current location by moving existing data to the right.) - Shift: DOWN (Copies the data to the current location by moving existing data down.)
Technical Notes
- The Sheet name field is optional if the target is the first sheet of the Excel file. For any other sheet, it must be specified.
- The Copy as value parameter is crucial when dealing with Excel cells containing formulas. If unchecked, formulas will be copied, potentially leading to lost values if the context changes. Checking this option ensures only the calculated values are transferred.