Excel:...e::Plus(3pm)

🌸 Excel::Template::Plus 💅

the Excel::Template glow-up bestie — aka Excel::Template::Plus, an extension to the Excel::Template module. Perl, user contributed, iconic.

---

✨ SYNOPSIS ✨

okay so literally the whole vibe in one snippet:

use Excel::Template::Plus;

my $template = Excel::Template::Plus->new(
    engine   => 'TT',
    template => 'greeting.tmpl',
    config   => { INCLUDE  => [ '/templates' ] },
    params   => { greeting => 'Hello' }
);

$template->param(location => 'World');

$template->write_file('greeting.xls');

like. she does it all. 🫶

---

⚠️ DISCLAIMER ⚠️

ngl bestie, this is the very first release of this module 😭 it's an idea that the author and Rob Kinyon (the author of Excel::Template) had discussed many times, but never got around to doing. this is the first attempt at bringing this to reality, and it may change radically as it evolves, so be warned. 💀

fr fr. early days energy. buckle up. 🎀

---

💖 DESCRIPTION 💖

so this module is an extension of the Excel::Template module, which lets you use various "engines" from which you can create Excel files through Excel::Template.

the idea is giving main character energy to the existing (and very solid, no cap) excel file generation code in Excel::Template, but extending its more templatey bits with more powerful options. ✨

the only engine currently provided is the Template Toolkit engine, which replaces Excel::Template's built in template features (the LOOP, and IF constructs) with the full power of TT. this is similar to the module Excel::Template::TT, but expands on that even further to try and create a more extensive system. obsessed.

you can use this module to create Excel::Template-compatible XML files using one of the supported engines. for example, with the TT engine you could create a Excel::Template XML file like:

<workbook>
  <worksheet name="[% worksheet_name %]">
   [% my_cols = get_list_of_columns %]
    <row>
   [% FOR col = my_cols %]
     <bold><cell>[% col %]</cell></bold>
   [% END %]
    </row>
   [% FOR my_row = get_list_of_objects %]
    <row>
       [% FOR col = my_cols %]
        <cell>[% my_row.$col %]</cell>
       [% END %]
    </row>
   [% END %]
  </worksheet>
</workbook>

your TT template thus creates a XML file suitable to handing over to Excel::Template for processing. and Excel::Template::Plus simplifies the template-creation and handing-over process. she's helpful like that. 💅

🔮 Future engine/plans include: 🔮

• Pure Perl — this would allow you to write you Excel::Template files using Perl itself which would then output the XML for Excel::Template to consume. this would be modeled after the recently released Template::Declare module perhaps.
• TT Plugins/Macros/Wrappers — this is basically anything which will make the TT engine easier to write templates for. the author has experimented with some of these things, but was not happy with any of them enough to release them yet. 🙈
• HTML::Template — Excel::Template's templating features are based on HTML::Template, but the HTML::Template plugins and other goodies are not compatible. this engine would bring those things to Excel::Template. 🦋

---

🛠️ METHODS 🛠️

• new (%options) — this method basically serves as a factory for creating new engine instances (for which Excel::Template::Plus::TT is the only one currently). the only parameter that it requires is engine, all other parameters are passed onto the engine's constructor (see the individual docs for more details on what is required). ✨
• meta — access to the metaclass. short, sweet, iconic. 👑

---

🐛 BUGS 🐛

all complex software has bugs lurking in it, and this module is no exception. 😭 if you find a bug please either email the author, or add the bug to cpan-RT.

---

🙏 ACKNOWLEDGEMENTS 🙏

this module came out of several discussions the author had with Rob Kinyon. friendship wins fr fr. 🫶

---

👑 AUTHOR 👑

Stevan Little <stevan@cpan.org>

---

📜 COPYRIGHT AND LICENSE 📜

Copyright 2007-2014 by Infinity Interactive, Inc.

<http://www.iinteractive.com>

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

---

and that's the whole page bestie, no crumbs left 💅 this was Excel:...e::Plus(3pm), the User Contributed Perl Documentation, from perl v5.34.0, dated 2022-06-13. slay, bye! 🎀✨💖