Difference between revisions of "CALCCELL"

From iMath
Jump to: navigation, search
(Created page with "{{Keyword| <code>CALCCELL ( string , string , string )</code> | Access the value of a cell or a cell range in an Office Calc document. The first string contains th...")
 
Line 2: Line 2:
 
<code>CALCCELL ( [[string]] , [[string]] , [[string]] )</code>
 
<code>CALCCELL ( [[string]] , [[string]] , [[string]] )</code>
 
|
 
|
Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string contains the sheet name, and the third the cell reference. iMath will create a [[number]] or a [[string expression]], depending on the type of the Calc cell.
+
Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string 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.
 
|
 
|
 
|
 
|

Revision as of 18:46, 8 July 2017

Syntax

CALCCELL ( string , string , string )


Implemented in iMath since version 2.2.0 or earlier.

Explanation

Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string 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

See also

SETCALCCELLS SETTABLECELL TABLECELL