Insert and Delete Rows | Robility Docs

Insert and Delete rows

This activity is used to insert or delete a column from a specified worksheet.

Technical Reference:

	INPUT	Action: Specify the action to be performed by the bot.
		NumberOfRows: Specify the number of rows to be deleted or inserted.
		Password: Specify the password if the workbook is password protected.
		SheetName: Specify the sheet name to which the column has to be added.
		StartingRow: Specify the position from which the row has to be inserted or deleted.
	MISC	Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes.
		SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error
		Version: It specifies the version of the excel automation feature in use
	OUTPUT	Result: Define a Boolean value to validate the success state of the activity. This is not a mandatory field.

*Mandatory field to execute the workflow

The following example illustrates on how we can use the insert and delete rows activity to delete 4 rows from the “test” sheet starting from the 3^rd position.

Example:

1. Drag and drop a get excel object activity to the workflow.

2. Enter the file path of the excel file in which the worksheet to be worked on is present.

3. Drag and drop an insert and delete row activity into the Get Excel object activity.

4. Click on the insert and delete row activity.

5. Enter the action to be done, insert or delete. Here we will select delete.

6. Enter the number of rows to be deleted.

7. Enter the name of the sheet in which the rows must be deleted.

8. Enter the position from where the rows have to be deleted.

9. Execute the activity