Which part are you having problems converting to Perl? In the lack of any actual question/problem my advice would be to investigate Spreadsheet::WriteExcel which makes it trivial to create Excel documents, Spreadsheet::WriteExcel::Examples has many examples.

If you're looking for advice on learning Perl:

• perlintro
• http://learn.perl.org
• http://perldoc.perl.org
• The tutorials section of this site, including PerlMonks for the Absolute Beginner.

Update: fixed grammar error.

"..I want to convert the log files to xls. by bash script I converted it to csv.."

Since you have a csv file already, you will need Text::CSV_XS or Text::CSV module to read in your csv file and Spreadsheet::WriteExcel to write into an excel file as mentioned by marto.
Something like so:

#!/usr/bin/perl
use strict;
use warnings;
use utf8;

use Spreadsheet::WriteExcel;
use Text::CSV_XS;

my $csv = Text::CSV_XS->new( { binary => 1, allow_loose_quotes => 1, }
+ )
  or die "can't open CSV file" . Text::CSV_XS->error_diag();

my $wrkbook  = Spreadsheet::WriteExcel->new('new_file.xls');
my $wrksheet = $wrkbook->add_worksheet('new_file');

open my $fh, "<:encoding(utf8)", "Data.csv" or die "can't open file: $
+!";
while ( my $row = $csv->getline($fh) ) {
    $wrksheet->write_row( $., 0, [ @{$row} ] ); ## write to excel file
}
$csv->eof or $csv->error->diag();
close $fh or die "can't close file:$!";
[download]

Or use csv2xls out of Text::CSV_XS' examples folder:

$ csv2xls --help
usage: csv2xls [-s <sep>] [-q <quot>] [-w <width>] [-d <dtfmt>]
               [-o <xls>] [file.csv]
       -s <sep>   use <sep>   as seperator char. Auto-detect, default 
+= ','
                  The string "tab" is allowed.
       -e <esc>   use <sep>   as seperator char. Auto-detect, default 
+= ','
                  The string "undef" is allowed.
       -q <quot>  use <quot>  as quotation char. Default = '"'
                  The string "undef" will disable quotation.
       -w <width> use <width> as default minimum column width (4)
       -o <xls>   write output to file named <xls>, defaults
                  to input file name with .csv replaced with .xls
                  if from standard input, defaults to csv2xls.xls
       -F         allow formula's. Otherwise fields starting with
                  an equal sign are forced to string
       -f         force usage of <xls> if already exists (unlink befor
+e use)
       -d <dtfmt> use <dtfmt> as date formats.   Default = 'dd-mm-yyyy
+'
       -D cols    only convert dates in columns <cols>. Default is eve
+rywhere.
       -u         CSV is UTF8
       -v [<lvl>] verbosity (default = 1)
[download]


Enjoy, Have FUN! H.Merijn

Thanks. I have tried to run this, but I have an Error: "" Spreadsheet/WriteExcel.pm did not return a true value at test.pl line 6. BEGIN failed--compilation aborted at test.pl line 6."" in folder C:/Test where I run the scripts, I have: ActivePerl-5.16.1.1601-x86_64-linux-glibc-2.3.5-296175 Spreadsheet-ParseExcel-0.2602 Spreadsheet-WriteExcel-2.38 I dont know what else I should do so that I get rid out of this error. I would appreciated if you help me out.

Up until Excel 2007, Excel had a limit of 65,536 rows (and 256 columns) for a spreadsheet. Excel 2007 raised this limit to 1,048,576 rows (and 16,384 columns).

"Excel 2007 raised this limit to 1,048,576 rows (and 16,384 columns)"

Yes, shure. But who likes to have a spreadsheet with 1,048,576 rows ;-)

I'm just wondering about how i would do something like this.

Even splitting such a large log by timestamp into different worksheets is no fun.

But what else? Perhaps putting the whole stuff into a database and write some stored procedures that do the dirty mangle job(s) a.s.o...?

Best regards, Karl

«The Crux of the Biscuit is the Apostrophe»