activities
latest
false
Productivity Activities
Last updated Oct 10, 2024

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



  • Description
  • Project compatibility
  • Configuration
  • Example

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.