Re: Perl and Excel 10

However, the $sheet-> Activate fails with the message ‘Can’t call method “Activate” on an undefined value at ….

That implies the previous line didn't return a result:

$sheet    = $workbook -> Worksheets("Sheet1");
[download]

Perhaps you misspelled the name of the worksheet? Perhaps Microsoft's default naming scheme for the worksheets is different, perhaps due to localization.

Comment on Re: Perl and Excel 10 Download Code

Replies are listed 'Best First'.
Re^2: Perl and Excel 10 by davies (Monsignor) on Jan 31, 2011 at 12:35 UTC
That's a possibility I didn't consider, but it could very well be the problem. If so, it can be solved by changing the sheet assignment to:`my $sht = $wb->Sheets(1);` Regards, John Davies	[reply] [d/l]
Re^3: Perl and Excel 10 by Anonymous Monk on Jan 31, 2011 at 20:47 UTC
Perl only worked when I used the suggestion of using `$sht = $wb->Sheets(1);` [download] This was on a PC where a Spanish version of Windows is being used. Therefore many thanks to both contributors. I suspect I would have spent many hours trying to figure this one out by myself!	[reply] [d/l]