Read Cell Value

Read value of cell.

Reads the value 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 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

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

Output

• Output : Object Variable The variable that stores the data extracted from the specified Excel Cell.