This is code snippet Where i am reading a xls file called delaytemplate

my $parser_delaytemplate_oop = Spreadsheet::ParseExcel::Save +Parser->new(); my $parser_delaytemplate_handler = $parser_delaytemplate_oop->Pars +e($open_thisoo) or die "Unable to open $open_thisoo\n, $!"; my $delaytemplate_me = $parser_delaytemplate_handler->worksheet(0) +; for(my $i = 0 ; $i < 1000000 ; $i++) { my $parser = $delaytemplate_me->get_cell(0, $i+1); if($parser) { $corners_xls[$counter_corners_xls++]= $parser->value(); } else { last; } }

This snippet is in a subroutine which is called around 500 to 3000 times. When i am calling this code snippet for 500 times, there are no errors. When i am calling this code snippet for more times like around 3000, then all the values are showing up as unintialized, despite me reading the same xls file in both cases. In each subroutine call, I am reading the same xls file multiple times. Does my library provide any limitations on number of times I can read the same xls file?


In reply to xls file number of reads limit? by breadbonda

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.