delete_rows
Delete rows from an Excel sheet, shifting remaining rows upward. Optionally skip LibreOffice recalculation for complex workbooks.
Instructions
Delete rows, shifting the rows below them upward.
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 start deleting from. count: Number of rows to delete. 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 | |||