XLSetCell

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

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

Example

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

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