Copy Excel worksheet Action(Power Automate Desktop)
This Action is that duplicates an existing worksheet.
How to use
First, specify the target Excel file in the Launch Excel Action or the Attach to Running Excel Action, then drag the "Copy Excel worksheet" Action from "Excel.Advanced" onto the workspace.
Set parameters.
The edited contents will not be reflected in the file as is.
If you wish to keep the edited content, you must save it using Save Excel Action or Close Excel Action at the end.
Parameters
Excel instance
Specify the target Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Copy worksheet with
Select how to specify the worksheet to copy.
- Name
- Index
Worksheet index
Specify the worksheet to be copied by giving it a sequential number, starting from 1.
Worksheet name
Specify the worksheet to be copied by its name.
Target Excel instance
Specify the Variables produced in the Excel file to be copied using the Launch Excel Action or the Attach to running Excel Action.
If the same specification as “Excel instance” is used, the copy will be in the same file.
Worksheet new name
Specify the name of the copied worksheet.
If the worksheet name already exists, the copy will fail.
Paste worksheet as
Select whether the copied worksheet is at the beginning or end of the file.
- First worksheet
- Last worksheet
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.