manageRowsAndColumns
Insert, delete, or auto-size rows and columns. Operations are executed in order: column insert → column delete → row insert → row delete → column autosize → row autosize.
| Parameter | Type | Description | |
|---|---|---|---|
sheet | string | required | Sheet name to operate on |
columns | object | optional | Column operations |
columns.insert | object | optional | |
columns.delete | object | optional | |
columns.autoSize | string[] | optional | Array of column letters to auto-size (e.g., [“A”, “B”, “C”]) |
rows | object | optional | Row operations |
rows.insert | object | optional | |
rows.delete | object | optional | |
rows.autoSize | number[] | optional | Array of 1-based row numbers to auto-size (e.g., [1, 2, 3]) |
note | string | required | Description of this operation for version history |