This is the same error as in your previous question, and you didn't even give us the full error message which tells you which line of code to start looking at:


D:\junk>perl xl.pl
Garry--> Sports

Jasen--> Sports


Can't call method "value" on an undefined value at xl.pl line 55.

[download]

Since we've been round this loop before, I suggest you take a look at the line of code in question and the actual data stored within Excel, the documentation for the get_cell, row/col_range methods and the previous thread explaining the problem.

In reply to Re: How to parse excel files having multiple tables with different number of elements? by marto
in thread How to parse excel files having multiple tables with different number of elements? by ankit.tayal560

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.