Set table
set_tableCreate or modify Excel tables: configure range, style, header and totals rows, calculated columns, filters, and resizing.
Instructions
Create a table, or change one: options, calculated columns and totals, resizing.
An existing table of that name on the sheet is changed; otherwise range (with a
header row of unique text labels) makes a new one, as in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Table name. Default for a new table: TableN. | |
| path | Yes | ||
| range | No | New table: the range with its header row. Existing table: resize to this range (same top-left cell). | |
| sheet | Yes | ||
| options | No |