I am using the following to open an excel workbook and access a sheet.
my $BucketizedFile = "C:\\temp\\Bucketized.xls";
$BucketizedOutputFile = $Excel->Workbooks->Open($BucketizedFile);
my $BucketizedKPI2Sheet = $BucketizedOutputFile->Worksheets("Sheet2");
I get the following error:
Can't call method "Worksheets" on an undefined value at Bucketizer_Worksheets_Issue.pl line 347.
It seems that it was unable to open the Excel sheet successfully.
I only see this on one particular PC. Why this inconsistency in behavior.
Any ideas what might be cauing this?
Appreciate your help.