The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

Csv2Xls - Convert one or more csv to one xls.

SYNOPSIS

#Example of csv1.csv file

titlecolumn1;titlecolumn2;titlecolumn3; aaa;bbb;ccc; fff;ggg;hhh;

-------------------------------------------------------------------

use Csv2Xls;

@fileCsv = ('csv1.csv', 'csv2.csv');

%hashRef = (

                  fileName=>'test.xls',  

                  titleAlign =>'center', 

                  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

AUTHOR

Cladi, cladi@cpan.org

COPYRIGHT AND LICENSE

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.