append_rows
Add rows to a specified sheet in an Excel workbook after the last used row. Optionally create the sheet if missing and recalculate formulas.
Instructions
Append rows after the last used row of a sheet, then recalculate the workbook.
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. rows: List of rows, each a list of cell values in column order. create_sheet_if_missing: Create the sheet first if it doesn't exist yet. recalculate: Run the LibreOffice recompute pass after saving.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| rows | Yes | ||
| sheet | Yes | ||
| recalculate | No | ||
| create_sheet_if_missing | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||