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.

 

Abbreviation: XGC

See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLGet, XLGetSheetDims, XLOpen, XLQuit, XLRun, XLSave, XLSetCell, XLGetSheetNames

 

Example

 

XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook

XLGetCell>xlBook,Sheet1,2,2,strValue