René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Excel and PERL

use warnings;
use strict;

use OLE;

my $excel = CreateObject OLE 'Excel.Application' or die $!;
$excel->{'Visible'} = 1;

my $workbook = $excel -> Workbooks -> Add;

$workbook -> ActiveSheet -> Range('A1')->{'Value'} = "Hello";

$workbook -> ActiveSheet -> Range('C2:D3')->{'Value'} = [ 
  ['one',   'two' ],
  ['three', 'four'],
];

$workbook -> SaveAs ('C:\\perl.xls') or die $!;

$excel -> Quit;

The excel object model

Links

Spreadsheet::WriteExcel: Write formatted text and numbers to a cross-platform Excel binary file.