EXCEL_READ$()

EXCEL_READ$(C)

READS THE CONTENT OF THE CELL C OF THE CURRENT SHEET WITH MICROSOFT EXCEL

  • Type: Function
  • Parameter: 1
  • Group: Excel

ACTION

The function EXCEL_READ$(C) returns a string which is the content of the cell defined by C in the current sheet of Microsoft Excel, if it is running.

Remark: the keyword EXCEL_READ$ ends by '$' : it means that the returned value is a string.

SYNTAX: Result$=EXCEL_READ$(C)

  • C : string (text or string variable) representing the cell coordinates (Example : "B2")
  • Result$ is a string

USE

  • The function EXCEL_READ$() is used to read the content of a cell in a sheet of Microsoft Excel.

ERROR

  • If C is not a correct string expression.
  • If Excel software is not running.
  • If no sheet (file) is opened.

EXAMPLE

rem launch Excel software

excel_start

rem wait for 5 secondes

wait 5000

rem create a new file

excel_file_new 1

rem write "Hello" in cell A1

excel_write "A1","Hello"

rem print content of the cell A1

print excel_read$("A1")

SEE ALSO

EXCEL_STOP

EXCEL_START

EXCEL_FILE_NEW

EXCEL_WRITE