Excel:...eRange(3pm)

💖 Excel::Template::Element::MergeRange 💖

okay bestie, so this is the page for Excel::Template::Element::MergeRange — yes the name is giving the same thing twice, that's just how it's listed, don't come for me. It lives in the User Contributed Perl Documentation, and it's a lil Perl module that exists to do exactly one iconic thing. Let's get into it 🎀

---

✨ PURPOSE ✨

To merge a range of cells in a spreadsheet. that's it. that's the whole job. she's a specialist, not a generalist 💅

---

🌸 NODE NAME 🌸

MERGE_RANGE

that's the name you call her by in your template, no cap.

---

🦋 INHERITANCE 🦋

ELEMENT

she's an element, she inherited that energy from ELEMENT, periodt.

---

🔥 EFFECTS 🔥

This will merge a range of cells. (yes, the effects section is literally just the purpose again — the original said it twice and I'm not about to gatekeep that from you, fr fr)

---

💜 DEPENDENCIES 💜

None. she's independent, she's self-sufficient, she does not need you or your other modules. main character energy only 👑

---

🌈 USAGE 🌈

okay so here's the vibe. you drop some cells, then you hit 'em with the merge_range:

<cell ref="foo"/>
<cell ref="foo"/>
<cell ref="foo"/>
<merge_range ref="foo">Text to insert into merged range</merge_range>

Or a cross rows:

<row>
  <cell ref="foo"/>
  <cell ref="foo"/>
  <cell ref="foo"/>
</row>
<row>
  <cell ref="foo"/>
  <cell ref="foo"/>
  <cell ref="foo"/>
  <format>
    <merge_range ref="foo">Text to insert into merged range</merge_range>
  </format>
</row>

see how the second one wraps the merge_range in a <format>? yeah. cross-row merging needs the glow-up, iykyk ✨

---

🫶 AUTHOR 🫶

Stevan Little (stevan.little@iinteractive.com) — shoutout to the legend, we love a credited icon 💖

---

💀 SEE ALSO 💀

Nothing. genuinely nothing. not a single related page. she stands alone 🧚

---

okay and that's the whole page bestie, no crumbs left. this one shipped as part of perl v5.34.0, dated 2022-06-13, and it's filed under User Contributed Perl Documentation. mwah, go merge something gorgeous 💅✨🌸