Read Cell Value
Read value of cell.
Reads the value of an Excel cell and stores it in a variable.
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 data is to be read.
Cell :
String Argument
The name of the cell in which the cell value is to be read.
Preserve Format :
True
- keeps the formatting of the excel cell that you want to read. The available formatting properties are:CellName
Format Specifier
Value
False
- Read the cell without formatting.Default
Output
Output :
Object Variable
The variable that stores the data extracted from the specified Excel Cell.
Last updated