Insert, delete or size rows and columns
xlide_manage_rows_columnsInsert, delete, resize, hide, show, group, or ungroup rows and columns in Excel files while preserving formula references. Works on .xlsx, .xlsm, and .xlam.
Instructions
Inserts, deletes, resizes, hides, shows, groups or ungroups whole rows or columns. Inserting and deleting move every reference in the workbook with them: a formula pointing below an inserted row follows it, and one pointing into deleted cells becomes #REF!, exactly as Excel does it. Deleting has no undo, so ask the user first. Widths are in characters and heights in points, which is what Excel's own dialogs use. Works on .xlsx, .xlsm and .xlam.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| size | No | For resize: column width in characters, or row height in points. -1 restores the sheet default. | |
| count | No | How many, counting from first. | |
| first | Yes | First row or column, 1-based. Column A is 1. | |
| sheet | Yes | Worksheet name, matched without case. | |
| which | Yes | 'rows' or 'columns'. | |
| action | Yes | insert, delete, resize, hide, show, group or ungroup. | |
| collapsed | No | For group: start the new group collapsed. | |
| file_path | Yes | Absolute path to the Excel file. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||