table
Manage Excel tables: create, resize, list, read data, toggle totals, or convert to range. Specify action, file path, and sheet name.
Instructions
Create, list, resize, toggle totals, read data, or convert tables to ranges.
Args: action: "create", "list", "resize", "totals", "data", or "convert_to_range". file_path: Workbook path. sheet_name: Worksheet containing the table. table_name: Table name for operations that require it. data_range: Range to use when creating a table. style_name: Named table style for creation. new_range: New range for resize. show_totals: Bool for toggling totals row. column_totals: Dict mapping column name to aggregation function name (e.g. {"Revenue": "sum", "Quantity": "count"}). Valid functions: sum, count, average, max, min, countNums, stdDev, var, none.
Returns: str | list[TableInfo] | dict
Notes: - Table creation/resizing mutates workbook structure.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| file_path | Yes | ||
| new_range | No | ||
| data_range | No | ||
| sheet_name | Yes | ||
| style_name | No | TableStyleMedium9 | |
| table_name | No | ||
| show_totals | No | ||
| column_totals | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |