ExcelToDatatable

This activity helps the user to convert the “Excel” sheet into “Datatable” format. It functions within the Excel scope activity.

Properties

INPUT

IncludeColumnHeader:Include the “Column Headers” from the Excel sheet when converting the data to the “DataTable” data type. If left blank, column headers will not be included in the conversion.

Sheet Name: *Provide the “SheetName” from which the data is to be converted. This parameter accepts values in the “String” data type.

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 converted sheet in “Datatable” format and returns the values 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.