delete_columns
Delete columns in an Excel sheet and shift remaining columns left. Specify sheet and start column, set count to remove, and optionally skip recalculation.
Instructions
Delete columns, shifting the columns to their right leftward.
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 start deleting from. count: Number of columns to delete. 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 | |||