ExcelScope

The “ExcelScope” activity serves as the scope for all other activities within this feature. All the functionalities which include creating new data, inserting content, deleting entries, extracting the data, writing data, and executing macro functions will be performed within this scope.

The Excel application should be closed during the runtime. 

Properties

INPUT

CreateNewWorkbook: Indicates whether to create a new workbook at runtime. You can check this box if required. If left unchecked, it will not be applied.

ExcelPath: *Specifies the “Path” of the Excel file for automation. To select the file, click the three dots next to “FilePath” in the activity. Alternatively, you can hardcode the path in a “String” variable or manually enter it as a “String” value. 

Password: Provide the “Password” to securely access the specified Excel sheet at runtime. This field accepts values in the “String” data type.

MISC

Body: Gets auto filled once the “Activity” is dropped into the body.

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

*Represents Mandatory field to execute the workflow.