xlsx_merged_cells
Identify merged cell regions in Excel workbooks with master values, ranges, and layout heuristics to recover visual structure lost in pandas reads.
Instructions
list every merged-cell region with master-cell value, range, span dimensions, and kind heuristic ("header" / "horizontal" / "vertical" / "block"). Pandas reads merged cells by dropping the relationship — it sees one value in the master cell and three blanks alongside. xlsx_merged_cells is the layout-aware view: "A1:D1 is ONE cell that says Q4 2024" rather than four cells where three are mysteriously empty. No other tool surfaces merges with master values rolled in: pandas drops merge metadata; openpyxl exposes ranges but not the master value alongside.
USE WHEN: parsing report templates, dashboards, or form workbooks where merges encode visual hierarchy (section titles, sub-headers, banner rows). Or auditing a workbook for accidental merges that distort downstream pandas reads. Free tier — counts against the 10k/mo cap.
DO NOT USE WHEN: you only need cell values and don't care about visual structure (use xlsx_read).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes | ||
| options | No |