setRangeValue

sets a value for the range

void setRangeValue(string range,any value, [string page] );
rangestringthe range of cells (or multiple ranges)
valueanya value for the range
pagestringoptional, 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".

See also
Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.
If you have not checked yet, be sure to visit site of our main product Webix ui component library and page of spreadsheet product.