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]