create_table
Convert an Excel range into a formatted table with named headers, banding, and total rows, using safe backups and preventing overlaps or name conflicts.
Instructions
Turn a range into an Excel table (ListObject) named name. With header true the first row supplies the column names (deduplicated); style is a built-in style; row_stripes and col_stripes toggle banding. totals maps columns to a function (sum, average, count, min, max...). Refuses an overlap with an existing table, and a name already taken by a table or defined name. Hazardous workbooks refuse unless allow_loss is true. Auto-backup to .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| path | Yes | ||
| sheet | No | ||
| style | No | TableStyleMedium9 | |
| backup | No | ||
| header | No | ||
| totals | No | ||
| location | Yes | ||
| allow_loss | No | ||
| totals_row | No | ||
| verify_com | No | ||
| col_stripes | No | ||
| row_stripes | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||