set_merge
Merge or unmerge Excel cell ranges, or list existing merges. Prevent accidental data loss by refusing merges that would discard values unless confirmation is given, and back up changes before saving.
Instructions
Merge or unmerge cell ranges, or list every merge. action is merge (location is the multi-cell range), unmerge (location must be the exact stored merged range), or list (read-only, one sheet or the whole workbook). Excel merge semantics: only the top-left value survives, so a merge whose absorbed cells hold values REFUSES until you pass confirm_data_loss=true, then reports exactly which values were discarded; overlapping an existing merge refuses. Unmerge keeps the surviving top-left value and leaves the rest blank. For the mutating actions: a hazardous workbook refuses unless allow_loss is true; auto-backup to prev/anchor slots in .ks4xl-backups; atomic verified save. Refuses while open in Excel.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | No | ||
| action | Yes | ||
| backup | No | ||
| location | No | ||
| allow_loss | No | ||
| verify_com | No | ||
| confirm_data_loss | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||