Excel:...::Range(3pm)

✨ Excel::Template::Element::Range ✨

okay bestie, buckle up, because this is the Excel::Template::Element::Range page from the User Contributed Perl Documentation and it's genuinely so useful 💖

---

🎀 NAME 🎀

Excel::Template::Element::Range — yes, that's it, that's the name, Excel::Template::Element::Range, she's literally her own description and honestly? iconic. 👑

---

💅 PURPOSE 💅

So what does she do? She hands you back a range of cell locations — think stuff like B2:C2 — and that range covers all the calls that used this reference. So if like three cells are all pointing at the same ref, she'll scoop them all up into one cute little range. 🫶

Now listen, if what you actually want is just the location of the last cell and not the whole squad? Use BACKREF instead. That's her whole thing. Don't mix them up, iykyk. 💀

---

🌸 NODE NAME 🌸

RANGE

that's the node name. short. sweet. main character energy. ✨

---

🦋 INHERITANCE 🦋

Excel::Template::Element

she's a child of Excel::Template::Element, inheriting the family genes, as she should. 🌈

---

💜 ATTRIBUTES 💜

• REF — this is the name of the reference you wanna look up. that's the whole attribute. one (1) job, and she does it flawlessly. 💖

---

🍓 CHILDREN 🍓

None.

no children. she's a free spirit. no dependents, no baggage, no little baby tags following her around. ✨

---

⭐ EFFECTS ⭐

None.

she doesn't change anything, she doesn't touch anything, she just is. very zen of her honestly. 🧘

---

🧚 DEPENDENCIES 🧚

heads up bestie: this one only works inside CELL tags. like, she will not function anywhere else. it's giving "must be in her designated area." 🎀

---

🔥 USAGE 🔥

okay so in this example right here...

<row>
  <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
</row>
<row>
  <formula>=SUM(<range ref="that_cell">)</formula>
</row>

the formula sitting in row 2 would come out as =SUM(B1:C1).

so basically the range grabbed both that_cell references and smooshed them into one range. obsessed. 💅

---

👑 AUTHOR 👑

Rob Kinyon (rkinyon@columbus.rr.com)

shoutout to Rob, the legend who made this all happen. 🫶

---

💖 SEE ALSO 💖

CELL, BACKREF

go read those too, bestie, they're friends of hers. 💜

---

and that's a wrap on the Excel::Template::Element::Range page!! 🌸

this whole thing came from perl v5.34.0 and got stamped on 2022-06-13, so like, it's vintage but it still slays. bye bestie, go make some beautiful spreadsheets 💅✨🎀