Read cell formula action in Microsoft 365 Excel

Use the Read cell formula action to retrieve a formula from an active or a specific cell and assign the output to a string variable. This action returns a blank value if the specified cell does not contain a formula.

Settings

  • Enter the name of the session used to open the workbook with the Open action.
  • Select the Active cell or Specific cell option to specify the cell from which to read the formula. If you have selected the Specific option, specify the address of the cell in the field.
  • Select a string variable to store the name of the formula from the Assign the output to variable list. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.