GOOGLE.SHEETS.ROW.INSERT
Premium
Experimental
Insert or append rows to a sheet.
Syntax
=GOOGLE.SHEETS.ROW.INSERT(Spreadsheet-Id, Sheet-Id or Sheet-Name, Cell Range, [Row Index])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to change. |
| Sheet-Id or Sheet-Name | Number,Text | ID or name of the sheet to add rows to. |
| Cell Range | Range | A cell range which contains the values of the rows to insert. |
| Row Index (optional) | Number | Index to insert rows at. If not specified new rows will be appended. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE if insert was successful. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Inserts values from range D2:F5 to rows starting at 5 in sheet S2 of spreadsheet with ID given in B2. |