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');
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.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.
FUNCTIONS
- cmp_excel_files($file1, $file2, $msg)
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.AUTHOR
Stevan Little <[email protected]>COPYRIGHT AND LICENSE
Copyright 2007-2014 by Infinity Interactive, Inc.This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.