Using Excel Scope
Purpose
Creates a scope for a given Excel document that could be used to perform required operations related to the document.
Description
The Using Excel Scope component enables to create a scope for a given Excel document that could be used to perform required operations related to the document. In the given example, a component is designed to open EmployeeDetails file file for performing required operations. Required components can be placed inside the Do component. (The Do component is automatically created at the time of Using Excel Scope creation.)
Note |
If Workbook property is not set, the Excel workbook will close after the execution of components created inside gets completed. In case it is set to a variable, the workbook remains open and the scope can be accessed using the variable mentioned in Workbook property. |
Properties
Property |
Data Type |
Description |
General |
|
|
Display Name |
String |
Display name of the component. |
Output |
|
|
Workbook |
Workbook |
Variable to save the Excel scope. The namespace of the variable datatype is TruBot.Excel.Workbook.Application. Note: The scope of the variable itself will be similar to that of any other variable. For example, if scope of the variable is defined within a given sequence, it can only be used only within that sequence. |
Preference |
|
|
Auto Save |
-NA- |
Saves the file automatically, if selected. |
Create New |
-NA- |
Creates a new file (in case the file does not exists), if selected. |
Macros |
-NA- |
Enables macros in the file, if selected. |
Read Only |
-NA- |
Opens the file in read‑only mode, if selected. |
Settings |
|
|
File Path |
String |
Complete file‑path of the Excel file whose scope is to be created. In case just filename is given, the component will attempt to search the file in the process directory. |
Password |
String |
Password to open the file, if required |
Password to Modify |
String |
Password to modify the file, if required |
Note: The property names marked with * sign are the mandatory properties. |