Insert rows or columns
insert_rows_or_columnsInsert empty rows or columns before a given position in Excel, shifting cells down or right; dependent formulas, merged ranges, charts, and tables are not updated.
Instructions
Insert empty rows or columns before position at, shifting the rest down or right.
Formulas, merged ranges, charts and tables that refer to shifted cells are not updated, so check them afterwards.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| at | Yes | 1-based row number, or 1-based column number (A=1). | |
| axis | Yes | Whether to act on rows or columns. | |
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| count | No | How many rows or columns. | |
| sheet | Yes | Worksheet name, e.g. 'Sheet1'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |