Read cell formula action

The Read cell formula action in the Excel advanced package enables you to retrieve the formula available in the Active cell or Specified 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 Specified cell option to specify the cell from which to read the formula. If you have selected the Specified cell 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.