Since it is a little qwirky getting started with OLE, here is some tested and verified barebones code to put a value in a cell of an excel sheet(using the default Book1.xls that is created when you open a new document in Excel.

Referencing the afformentioned documentation in excel will help explain how to accomplish the rest.

#!/perl -w

use strict;
use Win32::OLE;

my $excel = new Win32::OLE('Excel.Application');

my $workbook = $excel->Workbooks->Open("Book1.xls");

$workbook->Worksheets('Sheet1')->Range('A1')->{Value} = 'perl writing 
+to Excel';

$workbook->Save();

$excel->Quit();
[download]

that worked great. thanks. i also tried this:

$worksheet->Cells(1,1)->{Value} = "foo";

Of course, a Super Search for Win32::OLE and Excel reveals rather a lot of nodes, too... but if you have Excel installed the simplest way of learning how to "Automate" stuff is to use it's Macro Recording function (Tools Menu) and then hit ALT+F11 to view the code it recorded...

HTH - Mark