in reply to Re^2: Perl Excel OLE help
in thread Perl Excel OLE help
Hi MM,
You cannot access the sheet by name this way, because Excel is expecting the sheet index and not the name. You need to use the sheet index for 'Position', thusly:
my $Sheet = $Book->Worksheets(8);
Regards,
chinman
You cannot access the sheet by name this way, because Excel is expecting the sheet index and not the name. You need to use the sheet index for 'Position', thusly:
my $Sheet = $Book->Worksheets(8);
Regards,
chinman
In Section
Seekers of Perl Wisdom