in reply to Re^2: OLE write to Excel
in thread OLE write to Excel

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);

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

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/

Replies are listed 'Best First'.
Re^4: OLE write to Excel
by NewMonk2Perl (Sexton) on Jan 20, 2011 at 15:57 UTC
    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