Csv2Xls - Convert one or more csv to one xls.
use Csv2Xls;
@fileCsv = ('csv1.csv', 'csv2.csv');
%hashRef = (fileName=>'test.xls', titleAlign =>'center', #left, right standardAlign=>'left', columnSize=> 30, titleColor=> 'white', firstColumnTextColor=>'white', backgroundFirstRow=>'yellow', boldFirstColumn=>'yes', boldTitle =>'yes', boldStandardText=>'yes', colorStandardText=>'black', backgroundStandardRow=>'yellow', #or 'null' backgroundFirstColumn=>'red', #or 'null' alignFirstColumn=>'center', );
$instance1 = Csv2Xls->new(\%hashRef); #call the constructor $instance1->convert(@fileCsv); #conversion method
Cladi Di Domenico , <cladi@cpan.org<gt>
Copyright (C) 2012 by Cladi Di Domenico
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.12.3 or, at your option, any later version of Perl 5 you may have available.
To install Csv2Xls, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Csv2Xls
CPAN shell
perl -MCPAN -e shell install Csv2Xls
For more information on module installation, please visit the detailed CPAN module installation guide.