Definition and Usage
This command copies a worksheet from one Excel workbook to another or within the same workbook. It allows you to duplicate sheets between different Excel instances or create a copy within the current workbook with a new name.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Copy from Excel | The source Excel instance from which to copy the worksheet |
| Yes |
|
Source worksheet | The name of the worksheet to copy from |
| Yes |
|
Copy to | Choose whether to copy to the current workbook or a different workbook | Current Excel workbook, Another Excel workbook | Yes |
|
Copy to Excel | The target Excel instance where the worksheet will be copied |
| Required when "Copy to" is set to "Another Excel workbook" |
|
New worksheet name | The name of the new worksheet in the target Excel |
| Yes |
|
Overwrite existing worksheet | Check to overwrite the worksheet if a sheet with the same name exists |
| No | If unchecked, an error will occur when a sheet with the same name exists |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in the parameters of this command by clicking the {x} icon next to input fields. This allows you to dynamically set values such as source worksheet names or target worksheet names based on previously defined variables in your workflow.
Notes
Before using this command, ensure that both source and target Excel instances are properly initialized and open.
If the "Overwrite existing worksheet" option is not checked and a worksheet with the specified name already exists in the target workbook, the command will fail.
When copying between different Excel workbooks, make sure both Excel instances are valid and accessible.
The copied worksheet will maintain the same formatting, data, and formulas as the original worksheet.