XLGetCell

Top  Previous  Next

 

XLGetCell>XLBookHandle,SheetName,Row,Col,Result

 

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, XLGetSheetDims, XLOpen, XLQuit, XLRun, XLSave, XLSetCell

 

Example

 

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

XLGetCell>xlBook,Sheet1,2,2,strValue