Skip to main content

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