in reply to Re: Spreadsheet::ParseExcel MaxRow is maxing out at 2954
in thread Spreadsheet::ParseExcel MaxRow is maxing out at 2954
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 />"; } }
|
|---|