Excel tables
xlide_manage_tableList, add, or remove Excel tables to enable structured references and manage table data without broken addresses.
Instructions
Lists, adds or removes Excel tables, the ListObjects that Ctrl+T creates. A table names a block so formulas can say Sales[Amount] instead of an address that breaks when rows move, and it is what a Power Query load writes into. action='list' reads them and changes nothing. Adding one takes the column names from the header row of the range you give. Removing one leaves the cells and takes the table, so structured references to it break.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | Worksheet. Empty lists every sheet's tables. | |
| action | No | list, add or remove. | list |
| offset | No | For list: tables to skip. | |
| file_path | Yes | Absolute path to the Excel file. | |
| cell_range | No | For add: the range including its header row, such as A1:D20. | |
| table_name | No | For add and remove: the table's name. | |
| totals_row | No | For add: give the table a totals row. | |
| max_results | No | For list: most tables to return. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||