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

💖 Test::...e::Plus(3pm) 💖

okay so bestie, welcome to Test::Excel::Template::Plus, aka the little testing module that hangs out with Excel::Template::Plus and helps you check that the spreadsheet you just conjured out of thin air is actually... correct. yes, this is the Test::...e::Plus(3pm) page, and we're gonna go through it together. grab a strawberry 🍓

---

✨ NAME ✨

Test::Excel::Template::Plus — the testing module bestie for use with Excel::Template::Plus. that's it, that's the name, slay 💅

---

🌸 SYNOPSIS 🌸

here's the vibe, look:

  use Test::More tests => 1;
  use Test::Excel::Template::Plus;

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

  # compare the file we just made with
  # an existing example file ...
  cmp_excel_files("test.xls", "t/xls/test.xls", '... the excel files matched');

so you make your template, you write it out, and then you cmp_excel_files it against the example file you already trust. iconic behaviour honestly 👑

---

🫠 DISCLAIMER 🫠

not me being the bearer of bad news but... this module is woefully incomplete 😭

it does the job for the author's very basic purposes right now, but fr fr it is surely going to need lots of work in the future before it's actually usable. we're keeping it real with you. no cap.

---

💜 DESCRIPTION 💜

so what's the whole point of this thing? it attempts to give you a way to test and compare dynamically generated excel files. that's the mission 🎯

right now though, the only thing it supports is comparing two excel files for some approximation of:

• structural equivalence — meaning the values within cells
• visual equivalence — meaning the formatting of said cells

and here's the messy part 🙈 — because of how it's implemented, some elements may get compared that genuinely don't need comparing, and other things that do need comparing might get skipped entirely. it's giving chaos. this is gonna get refined as time goes by and as the module gets used in more heavyweight situations. character development arc loading... 🦋

---

🧚 FUNCTIONS 🧚

• cmp_excel_files($file1, $file2, $msg) — the one and only. you hand it two files and a message, and it does the comparison thing.

---

💀 BUGS 💀

all complex software has bugs lurking in it, and this module is absolutely no exception. if you find one, please either email the author, or add the bug to cpan-RT. do it, the author wants to know 🫶

---

👑 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!! ✨ this one came to you courtesy of perl v5.34.0, dated 2022-06-13, straight from the Test::...e::Plus(3pm) manual itself. mwah 💋 go forth and compare those spreadsheets, you absolute main character 💖🎀