Append workbook action
- Updated: 2022/11/18
Append workbook action
The Append workbook action in the Excel advanced package enables you to add all the worksheets from the specified workbook to the end of the currently open workbook.
Settings
- Enter the name of the session used to open the workbook with the Open action.
- Specify the workbook from which you want to append the worksheets in the Append from workbook field.
- If the workbook is protected, select the Password is required check box and enter the password in the To open field.
- In the To open field, provide your password with one of the
following options:
- Credential: Select a credential from the Credential Vault. Credentials and credential variables in the Bot editor
- Variable: Select a variable holding a credential data type value. Your variables (user-defined)
-
Insecure string: Enter a value or select a
variable.Important: Values entered using this option are not encrypted.