UiPath Activities

The UiPath Activities Guide

Read Cell Formula

UiPath.Excel.Activities.ExcelReadCellFormula

Extracts the formula used in the specified Excel cell. Can only be used in the Excel Application Scope activity.

Properties

Note:

Strings must be placed between quotation marks.

Input

  • Cell - The cell from which you want to extract the formula. Only String variables and strings are supported.

  • SheetName - The name of the sheet from which to extract the formula. By default, this is filled in with "Sheet1." Only String variables and strings are supported.

Output

  • Formula - The extracted formula as a String variable. An empty string will be returned if the cell contains no formula.

Common

  • DisplayName - The display name of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Example of Using the Read Cell Formula Activity

To exemplify how to use this activity, we have built an automation project that reads a cell formula and logs it to the console.
 
 
Download example

Updated 9 months ago


Read Cell Formula


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.