Difference between revisions of "EXCEL GET CELL"

From Macros Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
 
|param1=<row>|param1_desc={{row}}
 
|param1=<row>|param1_desc={{row}}
 
|param2=<col>|param2_desc={{col}}
 
|param2=<col>|param2_desc={{col}}
|param3=<nowiki><var name></nowiki>|param3_desc={{parameter_variable_any_name}} the cell contents
+
|param3=<nowiki><var name></nowiki>|param3_desc={{parameter_variable_string_name}} the cell contents
 
}}
 
}}
  
 
===Example===
 
===Example===
:EXCEL_GET_CELL 3, 6, r1
+
:EXCEL_GET_CELL 3, 6, a$
  
 
[[Category:Excel]]
 
[[Category:Excel]]

Latest revision as of 12:46, 12 January 2011

Up

Command

EXCEL_GET_CELL <row>, <col>, <var name>


Get the contents of a cell.

Parameters

<row>
Row number.
<col>
Column number.
<var name>
Name of string variable to be set to the cell contents

Example

EXCEL_GET_CELL 3, 6, a$