CALCCELL

From iMath
Jump to navigation Jump to search

Syntax

CALCCELL ( expression , expression , expression )

Implemented in iMath since version 2.2.0 or earlier.

Up to version 2.2.6 only literal strings are allowed, not string expressions.

Explanation

Access the value of a cell or a cell range in an Office Calc document. The first string expression contains the file name of the Calc document (relative paths are possible). The second string expression contains the sheet name, and the third the cell reference. iMath will create a number or a string, depending on the type of the Calc cell.

Example

EQDEF cell = "a1"

EQDEF t = CALCCELL("Unbenannt 1.ods", "Tabelle1", VAL(cell))

Note that VAL is required here to create a string expression from the variable.

See also

SETCALCCELLS SETTABLECELL TABLECELL