NAME

Csv2Xls - Convert one or more csv to one xls.

SYNOPSIS

#Example of .csv file

titlecolumn1;titlecolumn2;titlecolumn3;

aaa;bbb;ccc;

fff;ggg;hhh;

###################

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

AUTHOR

Cladi, <cladi@cpan.org<gt>

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.