Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 13, 2024

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.

  • Properties
  • Example of Using the Insert/Delete Rows Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.