Open Excel Activity
The Open Excel activity enables users to access an existing Excel workbook. This activity facilitates opening a specified Excel file, making its content available for subsequent automation tasks.
| Field | Description | Requirement |
|---|---|---|
| Excel name | A unique reference name assigned to the Excel file once opened, used for subsequent interactions within the automation. | Required |
| Excel file name | The full path to the Excel file to be opened. | Required |
| File password | The password required to open or modify an encrypted Excel file. | Optional |
Action Types & Examples
Excel Name
- Format: String
- Example Result:
exampleExcel
Excel File Name
- Format: String (File Path)
- Example Result:
C:\RobustaExample.xlsx
File Password
- Format: String
- Example Result:
1234
Implementation Examples
Field Setup - Excel name: exampleExcel - Excel file name: C:\RobustaExample.xlsx - File password: 1234
Execution Parameters - Excel name: exampleExcel - Excel file name: C:\RobustaExample.xlsx - File password: 1234
Technical Notes
Ensure the specified Excel file path is valid and accessible by the automation agent. For encrypted files, the
File passwordmust precisely match the file's encryption password. Incorrect passwords or inaccessible paths will result in an execution error.