Open Excel Activity
The Open Excel activity enables users to open an existing Microsoft Excel file. This activity facilitates interaction with Excel workbooks, allowing for subsequent data manipulation or extraction within automation workflows.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | Specifies a unique reference name for the Excel file that will be opened. This name is used to identify the Excel instance in subsequent activities. | Required |
| Excel File Name | Provides the full path to the Excel file to be opened. | Required |
| Visible | Determines whether the Excel application window is visible during execution. true displays the Excel window; false runs Excel in the background. | Optional |
Action Types & Examples
Excel Name
- Format: String
- Example Result:
myReportWorkbook
Excel File Name
- Format: String (file path)
- Example Result:
C:\Data\Reports\MonthlySales.xlsx
Visible
- Format: Boolean
- Example Result:
true
Implementation Examples
Field Setup - Excel Name: exampleExcel - Excel File Name: C:\RobustaExample.xlsx - Visible: true
Execution Parameters - Excel Name: projectData - Excel File Name: C:\Automation\Input\ProjectDetails.xlsx - Visible: false
Technical Notes
This activity requires Microsoft Excel to be installed on the machine where the automation is executed. Ensure the specified Excel file exists and is accessible by the automation process. If the file is already open by another process, the activity may fail or open a read-only instance, depending on Excel's default behavior.