Hi NewMonk2Perl, Welcome to the Monastery.

In the Perl community from time to time you'll hear/read "TMTOWTDI", meaning There's more than one way to do it. Have you seen the module Spreadsheet::WriteExcel? You can use it to create Excel documents on various platforms, you don't need excel installed. It has great documentation and Examples.

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

use Spreadsheet::WriteExcel;

my @mydata = (
    ['Item', 'Category', 'Price'],
    ['Nails', 'Hardware', '5.25'],
    ['Shirt', 'Clothing', '23.00']
    );

my $workbook = Spreadsheet::WriteExcel->new('test.xls');
my $worksheet = $workbook->add_worksheet();
$worksheet->write_col('A1', \@mydata);
[download]

If you're new to Perl I'd suggest working through the following:

• http://learn.perl.org
• http://perldoc.perl.org
• The Tutorials section of this site.

Update: I'll leave the formatting of the cells as an exercise for you, it's covered in the Documentation and the examples.

Update 2:Thanks toolc s/next/need/

Thank you for all the help and links to help me learn Perl. This is awesome information. There is just so much info on the net, its hard to seperate the good information from not so good information. Thanks again, Paul

I am using Win32::OLE for automatization of my Excel-tasks, and it works fine for me :-) . The main drawback of the module is that it requires Windows (and in my case also Excel) to be installed - so your scripts are not very portable.

Is this module not as good as the other modules to use with Excel?