Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^4: Doubt regarding parsing

by pavanpvss (Novice)
on Apr 04, 2012 at 19:10 UTC ( #963513=note: print w/ replies, xml ) Need Help??


in reply to Re^3: Doubt regarding parsing
in thread Doubt regarding parsing

use Spreadsheet::ParseExcel; my $filename = shift || 'C:\Earthlink.xls'; my $parser = Spreadsheet::ParseExcel->new(); my $workbook = $parser->parse($filename); if ( !defined $workbook ) { die $parser->error(), ".\n"; }

I have done exactly as you have told. But still i find the error "File Not found" . I have cross checked whether i have put the file in C:\ or not. I have done that. Can you please help me out. Thanks in advance


Comment on Re^4: Doubt regarding parsing
Download Code
Re^5: Doubt regarding parsing
by jandrew (Hermit) on Apr 04, 2012 at 19:39 UTC

    pavanpvss sometimes you are not in the directory that you thought you were in. Try adding the following line to your code and run it before the 'my $filename' line.

    map { print $_ . "\n" } <C:\*>;

    Then check the output for your file. (note the similarities of the C:\ to your filename call).

Re^5: Doubt regarding parsing
by ww (Bishop) on Apr 04, 2012 at 20:22 UTC
    No, you have not done "exactly" as toolic suggested. You're showing us single quotes around the file name. c.f. his line 3 at his first reply. See also any of the standard references re "interpolation."

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://963513]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (6)
As of 2014-09-15 11:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (147 votes), past polls