Activities
latest
false
Read Cell Formula - Other latest
logo
Productivity Activities
Last updated 2023年11月16日

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 or Use Excel File activities.

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

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