ReadRange

This activity helps the user to read and extract the range of values from the specified sheet. It functions within the “Excel Scope” activity.

Properties

INPUT

Range: *Specify the “Range” to read the data in the specified excel sheet, and it accepts values in the “String” datatype.

Sheet Name: *Specify the “SheetName” to read the data, and it accepts values in the “String” datatype.”

MISC

AutomaticCalculations: This parameter helps you to perform “Automatic calculations” if any formulas are available in the excel sheet. If left unchecked, it will not be considered.

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

IncludeColumnHeader: Include the “Column Headers” from the Excel sheet when extracting the data. If left blank, column headers will not be included.

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

Datatable: *It helps to view the output as extracted range in “Datatable” datatype. 

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.

 * Represents mandatory fields to execute the workflow.