XLGetCell>XLBookHandle,SheetName,Row,Col,Result
Not supported in Macro Scheduler Lite.
This function requires Microsoft Excel to be installed.
Retrieves the value in cell of given row,col coordinates from specified sheet name in workbook referenced by XLBookHandle. XLBookHandle is a handle returned by XLCreate/XLOpen.
Result is a variable name to store the retrieved value in.
To retrieve the underlying formula rather than the value first set XL_GET_FORMULAS to 1 (Let>XL_GET_FORMULAS=1) and remember to switch back to 0 for subsequent value retrievals.
Abbreviation: XGC
See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetSheetDims, XLGetSelectedCell, XLGetSheetNames, XLOpen, XLQuit, XLRun, XLRunCode, XLSave, XLSelectRange, XLSetCell, XLSetCellColor, XLSetRangeFormat, XLSheetToArray
Example
XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook
XLGetCell>xlBook,Sheet1,2,2,strValue