logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

Test::Excel::Template::Plus - Testing module for use with Excel::Template::Plus

Author

       Stevan Little <stevan@cpan.org>

Bugs

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

Description

       This module attempts to provide a means of testing and comparing dynamically generated excel files.
       Currently it only supports comparing two excel files for some approximation of strutural (values within
       cells) and visual (formatting of said cells) equivalence.

       As a by product of the implementation, elements may get compared which don't really need comparing, and
       things which do need comparing may be skipped. This will get refined as time goes by and the module is
       used in more heavyweight situations.

Disclaimer

       This module is woefully incomplete. It works for my very basic purposes right now, but it is surely going
       to need lots or work in the future to make it really usable.

Functions

cmp_excel_files($file1,$file2,$msg)

Name

       Test::Excel::Template::Plus - Testing module for use with Excel::Template::Plus

Synopsis

         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');

See Also