http://www.perlmonks.org?node_id=963513


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

Replies are listed 'Best First'.
Re^5: Doubt regarding parsing
by ww (Archbishop) 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."
Re^5: Doubt regarding parsing
by jandrew (Chaplain) 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).