delete_rows
Delete rows from an Excel sheet, moving remaining rows up. Specify sheet, start row, and count. 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 | |||