insert_columns
Insert blank columns into an Excel sheet, shifting existing data right. Specify start column and count, with optional skip of LibreOffice recompute for complex workbooks.
Instructions
Insert blank columns, shifting existing columns right.
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_column: 1-based column index to insert before. count: Number of columns to insert. recalculate: Run the LibreOffice recompute pass after saving.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| count | No | ||
| sheet | Yes | ||
| recalculate | No | ||
| start_column | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||