Using Excel Scope

Scope required: No

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.