Delete Rows

UiPath.MicrosoftOffice365.Activities.ExcelDeleteRowConnections

Description

Delete one or several rows from a specified position in a Workbook range. When you delete a row, the cells below are shifted up.

Scopes

This activity requires the following scopes:

• Sites.ReadWrite.All

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The target workbook to delete rows from. The method to specify the file to be retrieved: Browse, Enter Id, Enter Url.
  • Workbook sample - Select a file with the same ranges as the variable file. The field is visible after clicking Use workbook template. Browse the OneDrive folders and select a workbook. In Studio Desktop, the option is available from the Plus button menu next to Range. This field accepts IResource input. To learn more, see Working with templates.
  • Browse option - Click the Folder icon to browse the OneDrive or SharePoint folders and select a spreadsheet. This option accepts input as IResource.

    • Use the Plus button menu to use a variable or select the Reload Browser option if you've modified your folders and need to retrieve the latest data.

  • Enter Id option:
    • Workbook Id - The ID of the workbook of interest. This property supports String variables and string formatted values.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open your SharePoint site in a browser and copy its URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial.
    • SharePoint document library - The document library within the indicated SharePoint site that contains the file or folder. This property supports String variables and string formatted values. Open the Documents tab in your SharePoint site and copy the URL, e.g., https://yourcompany.sharepoint.com/sites/ProductOfficial/Shared%20Documents/Forms/AllItems.aspx.
  • Enter Url option:
    • Workbook Url - The URL of the workbook of interest. This property supports String variables and string formatted values. Retrieve the URL by opening the file in a browser.

• Range - Select a range or type a custom one (a full custom range can be used, i.e., Sheet1!A1:C10). This field is prepopulated with information retrieved from the selected spreadsheet. This property supports String variables and string formatted values.

  • Select the Update Ranges option if you've modified your sheets and need to retrieve the latest data.

• Rows - Specify the row indices to delete, or their range, separated by commas, e.g., 0, 2, 5-7. This property supports String variables and string formatted values.
• Delete behavior - Indicates the delete mode.
  • Clear - Clear the selected rows.
  • Delete - Delete entire sheet rows of the selection.

Output

• • Read information - Details of the selected range, stored in a RangeInformation variable.

Example

See also:

• Excel Online activities
• Delete Column
• Delete Range