Perl-Sensitive Sunglasses | |
PerlMonks |
Re: excelPerl V0.08by pKai (Priest) |
on Jan 12, 2007 at 14:43 UTC ( [id://594395]=note: print w/replies, xml ) | Need Help?? |
Proposed cleanup for the dirt mentioned in ExcelPerl.pm/getNextRow: my $rowData = $sheet->Range("A$row:IV$row")->{Value}; # dirty Idea: A range has a method address to stringify itself, giving the string one needs in the constructor à la range("A1:X1").
We can take an additional step (now in excelPerl.pl) and compile (eval) the $perCode only once:
Maybe we want the no warnings as shown in that tight scope, since our first change made it more likely that an index out of range for @F will be tried to access in the $perlCode. The former eval part in the while - getNextRow changes to $fn->(@F);with that.
In Section
Cool Uses for Perl
|
|