insert_rows
Add new rows to a spreadsheet at a specified position, shifting existing rows downward. Optionally populate inserted rows with data values or leave them blank for manual entry.
Instructions
Insert rows at a given position, shifting existing rows down.
If data is provided, the inserted rows are filled with those values (type-coerced). Otherwise the rows are left blank.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| row | Yes | 1-based row index where new rows will be inserted. Existing rows at and below this index shift down. | |
| count | No | Number of rows to insert. If data is provided and longer, enough rows are inserted to fit the data. | |
| data | No | Optional 2D array of values to fill the inserted rows. Leave empty for blank rows. | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |