UiPath Activities

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


Insert/Delete Rows


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.