InsertandDeleteColumn

This activity allows the user to add or delete the number of specified columns from the specified excel sheet. It must be used within the “Excel Scope” activity.

Properties

INPUT

Action: Indicates to choose the action from the drop-down.
Insert: Helps to insert number of specified columns in the specified sheet.
Delete: Helps to delete the number of specified columns from the sheet.

By default, it will be configured to “Insert” option.

NumberOfColumns: *Specify the number of columns to be added or deleted in the provided sheet. This parameter accepts values in the “Integer” data type, which can be either hardcoded in an “Integer” variable or directly entered as an “Integer” value. 

SheetName: *Specify the “SheetName” to insert/delete the column, and it accepts values in the “String” datatype.”

StartingColumn: *Specify the “Position” of the column to insert/ delete 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

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.