Read Cell Formula
Read formula of cell.
Last updated
Visualyze Documentation
Read formula of cell.
Last updated
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 : 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 : 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.
