Difference between revisions of "EXCEL GET CELL"

From Macros Wiki
Jump to: navigation, search
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[:Category:Excel|{{Up}}]]
 +
 
{{Command|syntax=EXCEL_GET_CELL <row>, <col>, <nowiki><var name></nowiki>
 
{{Command|syntax=EXCEL_GET_CELL <row>, <col>, <nowiki><var name></nowiki>
|description=:Get the cell's contents from excel, and set a variable for the contents for use in the macro.
+
|description=:Get the contents of a cell.
  
 
|param1=<row>|param1_desc={{row}}
 
|param1=<row>|param1_desc={{row}}
|param2=<col>|param2_desc={{row}}
+
|param2=<col>|param2_desc={{col}}
|param3=<nowiki><var name></nowiki>|param3_desc={{var name}}
+
|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$