SETCALCCELLS: Difference between revisions

From iMath
Jump to navigation Jump to search
(Created page with "{{Keyword| <code>SETCALCCELLS ( string , string , string , expression )</code> | Set the value of a cell range in an Office Calc document. The first string con...")
 
No edit summary
Line 7: Line 7:
|
|
|
|
[[CALCCELL] [[SETTABLECELL]] [[TABLECELL]]
[[CALCCELL]] [[SETTABLECELL]] [[TABLECELL]]
}}
}}
[[Category:Data exchange]]
[[Category:Data exchange]]

Revision as of 18:01, 8 July 2017

Syntax

SETCALCCELLS ( string , string , string , expression )


Implemented in iMath since version 2.2.0 or earlier.

Explanation

Set the value of 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 range reference. The dimensions of the cell range must match the dimensions of the expression (scalar, vector or matrix).

The Calc document is saved immediately after the change, during the recalculation of the iMath document.


Example

See also

CALCCELL SETTABLECELL TABLECELL