Re^2: No Excel data found in file

I have tried uncommenting the use Spreadsheet::ParseExcel; and running the code but now its giving me an error saying: Can't call method "worksheet" on an undefined value

Comment on Re^2: No Excel data found in file

Replies are listed 'Best First'.
Re^3: No Excel data found in file by roboticus (Chancellor) on Aug 22, 2014 at 12:11 UTC
a.alandkar: That means that the `parse` function failed. The problem might be that the .xls file isn't actually an Excel spreadsheet. I'd run the `file` command on the spreadsheet to verify it. Excel is (in my opinion) too lenient of file extensions--it will parse an HTML or CSV file with no problem even if it's got an .xls extension. ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: No Excel data found in file
by roboticus (Chancellor) on Aug 22, 2014 at 12:11 UTC

a.alandkar:

That means that the parse function failed. The problem might be that the .xls file isn't actually an Excel spreadsheet. I'd run the file command on the spreadsheet to verify it. Excel is (in my opinion) too lenient of file extensions--it will parse an HTML or CSV file with no problem even if it's got an .xls extension.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]
[select]