sets a value for a cell(s)
|cells||string||the id of a cell or a range of cells|
|value||string|number|array||the value(s) to be set for a cell/cells|
// setting value for one cell spreadsheet.setValue("A1",5); // setting the same value for a range of cells spreadsheet.setValue("A1:D1",5); // setting the same value for different cells spreadsheet.setValue("B6,A1:D1",5); // setting values from an array for cells in a range alternately spreadsheet.setValue("A1:D1",[1,2,3]);
1. The method allows setting the same/repeated value(s) for the specified cells. In case you want to add different values into spreadsheet cells, you'd better use the parse method.
2. Starting with v4.1, the reference to a cell or range of cells can be specified in the following format:
where sheet1 is the name of the tab.
In case the name of the tab isn't specified, the method will set the value(s) for the cell(s) of the active tab.