Re^4: How to convert Excel contents into a hash table and further access the contents of that hash table ?

Yes error is coming when I run the above code, plateform which I am using is : (1) Windows 7 (2) Active state perl 5.8.9 build 825 (3) Spreadsheet::ParseExcel 0.65

exact error message is :
Can't call method "value" on an undefined value at C:\perl\perl_tests\
+excel_parser.pl line 22
[download]

Comment on Re^4: How to convert Excel contents into a hash table and further access the contents of that hash table ? Download Code

Replies are listed 'Best First'.

Re^5: How to convert Excel contents into a hash table and further access the contents of that hash table ?
by Athanasius (Archbishop) on Oct 05, 2016 at 12:46 UTC

Well, you have the latest version of Spreadsheet::ParseExcel but a very old version of Perl. The oldest version I have on my computer at the moment is Strawberry Perl v5.12.3 (32 bit), which also runs the code you posted with no errors or warnings.

The best suggestion I can make is that you check your Excel file. If I add a blank line above the header — i.e., the line containing:

Student name  IQ  sports  Music  Academic
[download]

— then I get the error message you reported.

Hope that helps,

Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

[reply]
[d/l]