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.

results matching ""

    No results matching ""