InsertandDeleteRow

This activity allows the user to add or delete the number of specified rows from the 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 rows in the specified sheet.
Delete: Helps to delete the number of specified rows from the specified sheet.  

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

NumberOfRows: *Specify the number of rows 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 rows. This parameter accepts values in the “String” datatype.”

Starting Of Row: *Specify the “Position” of the row to insert/ delete from the provided sheet. The index position of the row 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.