The following is a copy paste of the spreadsheet near line 2954. I have tried adding and deleting rows to see if it effects the cap, but it still stops at 2954.

436	82995	Western New York Catholic Long-Term Care, Inc., Series 1993
		current refunded on May 5, 2004 by mortgage proceeds sales as follows:
		$10,045,000 called on 6/17/04 @ 101%
		
437	82996	Wartburg Home of Evangelical Lutheran Church, Series 1993
		current refunded on April 28, 2004 by mortgage proceeds sales as follows:
		$210,000 called 8/1/04 @ par.
		$15,060,000 called 8/1/04 @ 101%
***line 2954 here****		
438	82997	Elizabeth Church Manor NH Series 1993 current refunded on September 25, 2003
		by IDA bonds as follows:
		$6,725,000 called 10/27/03 @ 102%.

As for setting the spreadsheet, here is a more complete code fragment

    my $bk= $Excel->Parse("data/dasnyFootnotes.xls");
    my($r, $c, $wks);
    $wks= $bk->{Worksheet}[0];
    my $entry=0;




    for($r = $wks->{MinRow}; cell($wks,$r,0) !~ /^end$/i; $r++) {
        if(cell($wks,$r,0) =~ /^(\d+)$/) {
#print cell($wks,$r,0)."\n";
            $entry=$1;
            $html[$entry]->[0]= cell($wks,$r,1);
            $html[$entry]->[1]= ""; # pre init avoids warnings
            }
        if($entry > 0 && cell($wks,$r,2) ne "") {
            $html[$entry]->[1].= cell($wks,$r,2)."<br />";
            }
        }

[download]

In reply to Re^2: Spreadsheet::ParseExcel MaxRow is maxing out at 2954 by skelooth
in thread Spreadsheet::ParseExcel MaxRow is maxing out at 2954 by skelooth

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.