ReadColumn

This activity reads and extracts the specified column value from the specified sheet. It functions within the “Excel Scope” activity.

Properties

INPUT

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

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

Start Column: *Specify the “Position” of the column to read the data from the provided sheet. 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

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.