Delete rows or columns
delete_rows_or_columnsDelete rows or columns from an Excel sheet starting at a specified position, shifting remaining cells up or left. Check formulas, charts, and tables afterward; references are not updated.
Instructions
Delete rows or columns starting at position at, shifting the rest up or left.
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 |