Insert Rows

UiPath.MicrosoftOffice365.Activities.Excel.InsertRows

Description

Uses the Microsoft Graph Create row API to insert rows at the specified position in a table. Any rows below the inserted rows are shifted downwards.

Scopes

This activity requires the following scopes:

• Files.ReadWrite

OR

• Files.ReadWrite.All

OR

• Sites.ReadWrite.All

Project compatibility

Windows - Legacy | Windows

Configuration

Properties

Common

• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• Table Name - The name of the table. This property supports String variables and string formatted values.
• Workbook - The Drive Item of the Excel document. Use the Find Files And Folders activity to retrieve this Drive Item. This field supports only DriveItem variables.

Misc

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

What to Insert

• Empty Rows - The number of empty rows to insert. This field supports only integer and Int32 variables.
• Values - The values of the table rows to insert. This field supports only DataTable variables.

Where to Insert

• Insert Position - Where to insert the new rows. Select one of three options: Start, End, SpecificIndex. The default value is Start.
• Specific Index - The row number in the table after which to insert the new rows. Taken into consideration when Insert Position is set to SpecificIndex. This field supports only integer and Int32 variables.