GOOGLE.SHEETS.CELL.WRITE
Premium
Experimental
Write cells to a Google sheet.
Syntax
=GOOGLE.SHEETS.CELL.WRITE(Spreadsheet-Id, Sheet-Id or Sheet-Name, Cells, Cell Range or single value)
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to write cells to. |
| Sheet-Id or Sheet-Name | Number,Text | ID or name of the sheet to write cells to. |
| Cells | Text | A string conforming to Google cells notation which specifies the cells to write. |
| Cell Range or single value | Range | A single value to write or a cell range which contains the values to write. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE if write was successful. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Writes cells A1:C3 to sheet S2 of spreadsheet with the ID given in B2. |