Microsoft Office.Excel
Description
Opens an Excel Workbook by browsing the target folder.
Properties
Analyst
- Description: Optional text for documentation purposes.
Common
-
Continue On Error: Continues the execution of the workflow even if an error occurs during the execution of the activity.
-
Delay Before: Delay time in milliseconds before the activity is executed. The default value is 250 milliseconds.
-
Delay After: Delay time in milliseconds after executing of the activity. The default value is 250 milliseconds.
-
Disable Log: Disables the logging functionality for this activity.
-
Disable Protocol: Disables the protocol functionality for this activity.
-
Exclude from Global Delay: Excludes this activity from the Global Delay functionality.
-
Timeout: Duration in milliseconds in which the activity tries to execute.
Expert
- Create New If Not Existent: Choose to create a new excel workbook.
- Existing Workbook: Set variable to open an existing workbook.
- Remove Workbook Encryption: Whether the workbook encryption should be removed permanently. This will save the workbook decrypted.
- Set Workbook Password: Set password that is used to encrypt the workbook or change the current encryption password. Is only used if the "Remove Workbook Encryption" check box is unchecked.
- Workbook Password: Set password that is required to open an encrypted excel file.
Input
- Workbook Path: Set the path of the excel workbook to open.
- ExcelProvider: Choose your ExcelProvider. When using OfficeInteropt MS Excel needs to be installed, when using Syncfusion, that´s not necessary.
- Excel File Format: Select whether the xls or xslx format is used.
Options
- Maximize: Maximizes excel workbook window.
- Workbook Password: Set password for excel workbook.
- Update External Links: Choose to update external links.
- Hide Error Messages: Choose to hide error messages.
Output
- Workbook: Set name of workbook as output.