For Each Row in Workbook

UiPath.MicrosoftOffice365.Activities.Excel.ForEachRowConnections

Description

Iterates through the rows in a specified range within a worksheet.

Add the activities to repeat inside For Each Row in Workbook and, when you configure them, select Use Variable > CurrentRow from the See more button menu to indicate that you want to repeat the actions for each row in the iteration. For details, see Iterate through items with For Each activities.

Scopes

This activity requires the following scopes:

• Files.Read

OR

• Files.ReadWrite

OR

• Files.Read.All

OR

• Files.ReadWrite.All

OR

• Sites.Read.All

OR

• Sites.ReadWrite.All

Note: This activity uses pagination for processing large numbers of items and mitigating performance issues. This activity doesn't support persistence.

Project compatibility

Windows | Cross-platform

Configuration

• Microsoft OneDrive & SharePoint connection - The connection for the Microsoft 365 account to use in the activity.
• Workbook - The Excel workbook to use. The method to specify the folder to be retrieved: Folder picker, Enter Id, Enter Url.
  • Workbook sample - The workbook template to use. 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 See more button menu next to Range type. To learn more, see Working with templates.
  • File/Folder picker option: Click the Folder icon to browse the OneDrive or SharePoint files/folders and select a spreadsheet. This option accepts input as IResource.

    • Use the See more button menu to use a variable or select the Reload Folder Data 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 field supports String type input.
    • SharePoint site address - The URL of the SharePoint site that contains the file or folder. This field supports String type input.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 field supports String type input. 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 field supports String type input. Retrieve the URL by opening the file in a browser.
• Range - The range within which rows are iterated. This field is prepopulated with information retrieved from the selected spreadsheet or spreadsheet sample. 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.

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

• Has headers - Specifies whether the first row in the range represents a header row. By default, True is selected.

Additional options

Input

• If row is empty - Indicates the behavior to follow when an empty row is iterated. The available options are Skip, Process, and Stop.

Output

• Total number of sheets processed - The total number of sheets processed by the activity.

Body

The body of the activity that stores other activities used in the automation.

Known limitations for requests

Be aware of request/response limits when working with ranges. The limit stands at 4 MB, e.g., on average 10,000 cells with 20 characters each for Read requests, 4,000 cells with 20 characters each for Write requests. For more information, see Excel specifications and limits.

Note:

Batching API calls is supported for the following activities when used inside the For each:

• Add List Item
• Send Email
• Write Row
• Create Event

Example

See also:

• Excel Online activities

• Create Workbook
• Add Sheet
• Read Cell