Extracts the formula used in the specified Excel cell. Can only be used in the Excel Application Scope activity.
Strings must be placed between quotation marks.
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.
- Formula - The extracted formula as a String variable. An empty string will be returned if the cell contains no formula.
- DisplayName - The display name of the activity.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
To exemplify how to use this activity, we have built an automation project that reads a cell formula and logs it to the console.
Updated 9 months ago