Ugrás a fő tartalomhoz
Verzió: 15

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 parameterAssignmentValue formatInput options
Worksheet nameRequiredStringLocal, variable
Column nameRequiredStringLocal, variable
Row numberRequiredIntegerLocal, variable
Readout variableRequiredStringLocal, 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