GetWorkbookSheet

This activity helps the user to retrieve the sheet name from the specified excel workbook. It functions within the “Excel Scope” activity. 

Properties

INPUT

Index: *Specify the “Position” of the sheet from the Excel workbook. The index position of the column begins from “0” and it accepts values in “Integer” datatype. 

MISC

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.

Output

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

Sheet: This parameter retrieves the sheet name from the specified position in the workbook and returns the value in “String” data type.

* Represents mandatory fields to execute the workflow.