XL_ADDCELL2()

 

Version Ref: 6.1 (USP 6.0.02)

 

Syntax:

 

 e = XL_ADDCELL2([data [, style [, sheet [, cell]]]])
	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.
		cell  : The Excel style cell to insert the cell. e.g. "A1" "D6" "F6".

	Returns "1" on success and "-1" on error. XL_ERROR() can be called to return
	the last error.
	
	Note: Using an empty cell number 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 '='.