Worksheet Created

UiPath.MicrosoftOffice365.Activities.Excel.Trigger.WorksheetCreated

Description

Starts the automation when a new sheet within a workbook is created.

Note: It can take up to several minutes for the Microsoft API to register changes performed in an Excel file. This may lead to longer debug times for Excel activities and triggers, or to triggers not capturing events.

You must also be aware of when Excel files are updated. With Excel for Desktop, the database is updated when you click the Save button. With Excel Online, the database is updated when you close the Excel window.

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 workbook to use. This field supports IResource variables.
  • Reload browser - Select this option if you've updated your workbook and need to retrieve the latest data.
• Additional filters - Configure additional criteria to check on the created worksheet. Supports filtering on the following fields: Worksheet name.

Output

• Workbook - Workbook name. 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.
• Created worksheet - The created worksheet, which can be used further in the workflow. 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.

• Job Data - Contains job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution.

Example

See also:

• Excel Online activities