void=setCellString(col:integer, row:integer, val: string)
The function saves the content in the string format to a cell in xls document.
ParametersCol and row are coordinates of the cell, that we want to save the string value to. Col is a coordinate of column and row is a coordinate of row. The values range from firstCol to lastCol, respectively from firstRow to lastRow. Type of val is string and insert a text chain, that we save to a cell.
NoteWe can only save to a sheet, that exists. After insertion of values we can save the xls file using the function saveToFile, or we only re-read the values using the function getCellString and thus use the xls file, for example, for some calculations.
Example - Director
global xls
xls.setActiveSheet(1)
xls.setCellString(2, 10, "XTRA")
Example - AuthorwareCallObject(xls; "setActiveSheet" ; 1)
CallObject(xls; "setCellString"; 2; 10; "XTRA")