setRangeValue

sets a value for the range

void setRangeValue(string range,any value, [string page] );

range

stringthe range of cells (or multiple ranges) value

anya value for the range page

stringoptional, the name of the sheet you want to perform an operation on

Example

// sets a single range of cells
$$("ssheet").setRangeValue("A1:B2", [1,2,3,4], "Sheet2");
 
// sets multiple ranges of cells
$$("ssheet").setRangeValue("C3:E3;C5:E5", [[1,2,3],[4,5,6]], "Sheet2");

Details

The range parameter accepts multiple ranges with a semicolon as delimiter: "A1:C3;B4:D5".