Version Ref: 6.1 (USP 6.0.02)
Syntax:
e = XL_ADDCELL([data [, style [, sheet [, row [, col]]]]])
Add a new cell to the XLSX document.
Parameters -
data : Data to be inserted into the document. A cell starting with '='
will be treated as a formula.
style : Handle to style to be used for this cell. Use blank to use the
default style.
sheet : Handle to sheet to insert the cell on. Use blank, "0", or "-1"
to use the default sheet.
row : Row to place the cell (0 indexed).
col : Column to place the cell (0 indexed).
Returns "1" on success and "-1" on error. XL_ERROR() can be called to return
the last error.
Note: Using an empty or negative row/column value will cause the cell to be
added using the auto counter in the sheet, incrementing the column value
after the cell is added. Specifying a location will reposition the auto
counter. Formulas can be used as part of the data as well by prefixing the
string with '='.