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.