Skip to main content

Cell in Worksheet Updated

UiPath.MicrosoftOffice365.Activities.Excel.Trigger.WorksheetCellUpdated

Description​

Starts the automation when a cell within a worksheet is updated.

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.
  • Sheet - The monitored sheet name. This field supports String variables and string formatted values.
    • Select the Update Tables option if you've modified your workbook and need to retrieve the latest data.
  • Cell address - The monitored cell address. This field supports String variables and string formatted values.
  • Additional filters - Configure additional criteria to check on the updated cell.

Output

  • Workbook - The workbook name, saved to a O365DriveRemoteItem variable. 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.
  • Cell - Information about the updated cell. 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​

docs image

See also: