Read Cell Formula

Description

Extracts and returns the Formula used in the specified Excel cell of a spreadsheet.

Properties

Input

• Cell – Specify the cell to extract the formula.
• Sheet Name – Specify the spreadsheet to be used to extract the cell formula.
• Spreadsheet – Specify the instance of Excel Workbook.

Optional

• Continue On Error – Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False.

Note: If this activity is included in Try Catch and the value of this property is True, no error is caught when the project is executed.

Misc

• DisplayName – Add a display name to your activity.
• Private – By default, activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Output

• Formula – Returns the extracted Formula or empty string if the cell does not contain any formula.

Example

Download Example