insert_rows
Insert blank rows into an Excel sheet, shifting existing data down. Specify sheet, start row, and count to add empty rows, with optional LibreOffice recalculation.
Instructions
Insert blank rows, shifting existing rows down.
Set recalculate=False to skip the LibreOffice recompute (e.g. for structurally
complex workbooks you don't want round-tripped).
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. start_row: 1-based row index to insert before. count: Number of rows to insert. recalculate: Run the LibreOffice recompute pass after saving.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| count | No | ||
| sheet | Yes | ||
| start_row | Yes | ||
| recalculate | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||