For Each Sheet in Workbook

UiPath.MicrosoftOffice365.Activities.ForEachSheetConnections

Description

Iterates through the sheets within a workbook.

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

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

Scopes

This activity requires the following scopes:

• Sites.Read.All

OR

• 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 Excel workbook to use. The method to specify the folder to be retrieved: Folder picker, Enter Id, Enter Url.
  • 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.

Additional options

Output

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

  Can be used outside the For Each Row in Workbook activity. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.

Body

The body of the activity that stores other activities used in the automation, such as Read Range.

Example

See also:

• Excel Online activities

• Create Workbook
• Delete Sheet
• Read Cell