Insert/Delete Rows

UiPath.Excel.Activities.ExcelInsertDeleteRows

Adds or removes a specified number of rows at a certain position.

Properties

Common

• DisplayName - The display name of the activity.

Destination

• NoRows - The number of rows you wish to add or remove. This field supports only integers or Int32 variables.
• Position - The row where the insertion or removal begins. This field supports only integers or Int32 variables.

Input

• ChangeMode - Selects whether the activity adds or removes rows. Selecting Add will add rows to the document, while selecting Remove will remove them.
• SheetName - The name of the sheet in the workbook where the change must be made. This field supports only strings and String variables.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of Using the Insert/Delete Rows Activity

To exemplify how to use this activity, we have built an automation project which inserts rows at the beginning of a sheet.

Download example