EXCEL_READ_CELL

Reads out the value stored in a specific cell in an excel spreadsheet.

Description

Reads out the value stored in a specific cell in an excel spreadsheet. This command works only if an excel file was previously opened with the EXCEL_OPEN command. After all the operations with a specific excel file are done within a script, it is advised to close the excel file with the EXCEL_CLOSE command.

Syntax

EXCEL_READ_CELL [Worksheet name] [Column name] [Row number] [Readout variable]

Command parameters

Command parameter	Assignment	Value format	Input options
Worksheet name	Required	String	Local, variable
Column name	Required	String	Local, variable
Row number	Required	Integer	Local, variable
Readout variable	Required	String	Local, variable

Worksheet name:

Name of the worksheet within the currently opened excel file.

Column name:

Name of the column within the specified worksheet of the currently opened excel file.

Row number:

Number of the row within the column.

Readout variable:

Name of variable that will store the value read out from the specified cell.

Sample code

Command only:

EXCEL_READ_CELL Sheet1 A 1 Cell_Readout

With added open and close commands:

EXCEL_OPEN c:\Temp\Sample_Excel.xlsx

EXCEL_READ_CELL Sheet1 A 1 Cell_Readout

EXCEL_CLOSE