Problems? Is your data what you think it is? | |
PerlMonks |
Re: Help with Excel::Tableby Athanasius (Archbishop) |
on Sep 25, 2020 at 15:08 UTC ( [id://11122206]=note: print w/replies, xml ) | Need Help?? |
Hello BernieC, It looks like there’s a mismatch between (1) the regular expression used to separate directory and filename, and (2) the actual input. The regex /(.*)\/(.*)/ splits on a forward slash, but the input contains either a backslash (from the error message) or no slash at all (from the specified input: getWB("D:myexcel.xlsx")). It’s safer to use the core module File::Basename here:
Whether this is your real problem, I don’t know, but at the least it’ll remove one layer of possible confusion as you seek to debug the problem. In that case, the monks will require more information — preferably in the form of an SSCCE — to be able to assist with the debugging process. Hope that helps,
In Section
Seekers of Perl Wisdom
|
|