Insert Table Column

This activity helps the user to add a new column to the specified table in the excel sheet. It must be utilized within “Excel Scope” activity. 

Properties

INPUT

ColumnName: *Specify the name of the column to be created in the table and it accepts the values in “String” datatype. 

Position: Specify the position where the column needs to be inserted in the table. It accepts ‘Integer’ values, which can be hardcoded or provided from an “Integer” variable.
If left blank, the column will be inserted at the end of the table. 

SheetName: *Specify the “SheetName” where the column needs to be inserted in the table, and it accepts values in the “String” datatype. 

TableName: *Specify the name of the table where the column needs to be created, and it accepts values in the “String” 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.

* Represents mandatory fields to execute the workflow.