manage_sheets
List, add, delete, rename, copy, activate sheets, or insert and delete rows and columns in Excel workbooks using xlwings.
Instructions
Manage sheets and structure.
Args: action: One of 'list', 'add', 'delete', 'rename', 'copy', 'activate', 'insert_rows', 'delete_rows', 'insert_columns', 'delete_columns'. workbook: Workbook name or path. Defaults to active workbook. sheet: Target sheet name (required for delete/rename/copy/activate). new_name: New name (for rename; optional for add/copy). position: Row/column number (1-based) for insert/delete actions. count: Number of rows/columns to insert or delete.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| workbook | No | ||
| sheet | No | ||
| new_name | No | ||
| position | No | ||
| count | No |