create_table
Create a formal Excel Table (ListObject) on a specified cell range to add filters, row stripes, and styles while preserving workbook structure.
Instructions
Create a formal Excel Table (ListObject) on the specified range.
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. cell_range: A1-style range (e.g. "A1:D10"). table_name: Unique table identifier across the workbook. style_name: Table style name (e.g. "TableStyleMedium9"). show_filter: Whether to display auto-filter dropdown arrows. show_row_stripes: Whether to apply alternating row shading. backup: Whether to create a backup before modifying the workbook.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| sheet | Yes | ||
| backup | No | ||
| cell_range | Yes | ||
| style_name | No | TableStyleMedium9 | |
| table_name | Yes | ||
| show_filter | No | ||
| show_row_stripes | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||