|
<< Click to Display Table of Contents >> Navigation: 3. Script Language > Browser and Office (Acc.-Engine) > OFC. - Office-Commands > MS-Excel Scripting > OFC. - Office-Commands |
MiniRobotLanguage (MRL)
OFC.Excel|LETTER_TO_NUMBER
Convert a numeric value int othe Alphabetic value of the Excel X-Axis
Intention
This command does not need Excel to be opened. It is a pure mathematical operation.
It will convert a pure Excel-X-Axis "Letter-Number" to a numeric representation.
It is the logical opposite from the "NUMBER_TO_LETTER" command.
' Convert "DD" to "99"
OFC.Excel|LETTER_TO_NUMBER|DD|$$RES
DBP.$$RES
Syntax:
OFC.Excel|LETTER_TO_NUMBER|P1[|P2]
Parameter Explanation:
P1 - (numeric) value that specifies the excel representation of a Cell on the X-Axis starting with "A".
P2 - (optional/Variable) Variable that will receive the numeric result of the operation. If omitted, TOS is used.
Example:
' Excel NUMBER_TO_LETTER Example
OFC.excel|OPEN||0|1
OFC.Excel|LETTER_TO_NUMBER|ZZZ|$$RES
DBP.$$RES
OFC.Excel|NUMBER_TO_LETTER|$$RES|$$LET
DBP.$$LET
MBX.Click to Close
OFC.excel|CLOSE|1
END.
Remarks:
-
Limitations:
These commands need an valid Installation of MS-Office Excel. It will check if MS Excel is properly installed, and if not just do nothing.
Will work on a large range of numbers at least from "A" to "ZZZZZZZ" (equals 236852010). Which is more then any Excel will possibly provide in the near future.
See also: