XLSetCell


 

XLSetCell>XLBookHandle,SheetName,Row,Col,Value,Result

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Sets 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 will contain zero if the operation was successful, otherwise will contain the Excel error message.

 

Value is the value to set.

 

Abbreviation: XSC

See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetCell, XLGetSheetDims, XLGetSelectedCell, XLGetSheetNames, XLOpen, XLQuit, XLRun, XLRunCode, XLSave, XLSelectRange, XLSetCellColor, XLSetRangeFormat, XLSheetToArray 

 

Example

 

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

XLSetCell>xlBook,Sheet1,2,2,'205,res

XLSave>xlBook,%USERDOCUMENTS_DIR%\mybook.xls

XLQuit>xlBook