Using Append worksheet action

Use the Append worksheet action to add a worksheet from an existing workbook to current workbook.

Prerequisites

While adding a worksheet into a workbook, ensure that no other worksheet with the same name exists. However, if a worksheet with the same name exists in the workbook, rename the worksheet that you want to add or append.

Procedure

  1. Double-click or drag the Append worksheet action.
  2. Use the Append from workbook field to select one of the following tabs to specify the location of the worksheet:
    • Variable: To select an existing variable that represents a workbook.
    • Control Room file: To select a workbook from the Control Room.

      Click Choose to select the workbook.

    • Desktop file: To select a file from your desktop.

      Click Browse to select the file.

  3. Optional: Select the Password is required check box if you want to enforce a password requirement to open the worksheet, and select one of the following tabs:
    • Credential: To use a value available in the Credential Vault as the password.

      Click Pick to select the value.

    • Variable: To select an existing variable as the password.
    • Insecure string: To enter or specify the values.
  4. Use the Worksheet to be appended from the workbook field to select one of the following:
    • Enter worksheet name: To specify the name of the worksheet that you want to append.
    • Enter worksheet index: To specify the index of the worksheet that you want to append.
    The worksheet for either of the above selections will be appened to the workbook that you have used in the Open action.
  5. Enter the name of the session used to open the workbook with the Open action.
    You can also use the Variable tab to select an existing variable for the session name.
  6. Click Save.