I'm trying to do some Excel hacking and Excel::Table looks like the perfect module. but I can't get it to open a spreadsheet. my 'open' subroutine is simple:
sub getWB
{ my ($dir, $excel) = $_[0] =~ /(.*)\/(.*)/ ;
my $xs = Excel::Table->new(dir => $dir) ;
$xs->open($excel) ;
return $xs ;
}
and when I try to open the spreadsheet with 'getWB("D:myexcel.xlsx")' I get
Log4perl: Seems like no initialization happened. Forgot to call init()
+?
no such path [D:\myexcel.xslx] at D:\Perl\spreadsheet.pl line 55.
Any advice at what I'm missing/getting wrong? Thanks