Read Cell Formula

Read formula of cell.

Reads the formula of an Excel cell and stores it in a variable.

This activity can only be used after the Open Excel File activity.

Input

  • Input : ExcelHandle Variable A variable name that references the opened excel file handle.

  • Sheet Name : String Argument The name of the sheet in which the cell formula is to be read.

  • Cell : String Argument The name of the cell in which the cell formula is to be read.

The starting cell is specified in A1 format. A1 will select first cell from first row.

Output

  • Output : Object Variable The variable that stores the formula extracted from the specified Excel Cell. If there is no formula in the specified cell the output generated will be null.

PreviousRead Cell ValueNextGet Cell Color

Last updated