Moving Worksheets
Activity Description
To move an Excel worksheet to another Excel file, or to another location in the current Excel file
Property Description
Worksheet Name
Enter the name of the sheet to be moved, default is “Sheet1”.
Target index
Enter the index of the location where the sheet is to be moved
Note: 0 means first, 1 means second
Target worksheet name
Input the name of the sheet after moving
Target file path
Enter the full path of the target file to which the worksheet is moved (you can also click the icon to the right of the input box to select the full path of the file)
File Path Input the full path of the source file to be moved (you can also click the icon to the right of the input box to select the full path of the file)
Example of using
Steps:* Move the “Sheet1” worksheet in the source file to the first worksheet in the target file.
Note: When executing the activity, first close the Excel file to be used for the activity, and it cannot be in the same Excel sheet.