Re^2: Iterating Through Cell Blocks with Spreadsheet::Read

Replies are listed 'Best First'.
Re^3: Iterating Through Cell Blocks with Spreadsheet::Read by chexmix (Hermit) on Oct 08, 2013 at 18:30 UTC
I hate to post this because it sounds condescending -- I don't mean it that way, honest! You know you have to do this with all the lines where you have such a hash key (e.g. the ones with "_29", "_30", etc), right? Not just the _28 one. I've been trying to get toolic's suggestion to not work, here, and I haven't succeeded.	[reply]
Re^4: Iterating Through Cell Blocks with Spreadsheet::Read by chexmix (Hermit) on Oct 08, 2013 at 18:31 UTC
Oh, sorry, I misread your post. Please ignore mine above. :(	[reply]
Re^5: Iterating Through Cell Blocks with Spreadsheet::Read by Hammer2001 (Novice) on Oct 08, 2013 at 18:42 UTC
Yes indeed, chexmix, recommended change was made on all affected lines. Here's the revised test script: `use Spreadsheet::Read; my $inbook = "Data_File.xlsx"; $book = ReadData ($inbook); my @x = qw(F G H I J K); for my $sheet_index (1 .. $sheet_count) { my $sheet = $book->[$sheet_index] or next; foreach (@x) { $name = $sheet{"${_}28"}; $strain = $sheet{"${_}29"}; $initdensity = $sheet{"${_}30"}; $finaldensity = $sheet{"${_}31"}; $avedensity = $sheet{"${_}32"}; print "Found sheet with label: $sheet{label}\n"; print "COL=$_ $name $strain $initdensity $finaldensity $avedens +ity\n"; } }` [download] Hopefully it helps you see my error. Regards, Hammer	[reply] [d/l]
Re^6: Iterating Through Cell Blocks with Spreadsheet::Read by AnomalousMonk (Archbishop) on Oct 08, 2013 at 19:55 UTC
Re^7: Iterating Through Cell Blocks with Spreadsheet::Read by Hammer2001 (Novice) on Oct 08, 2013 at 20:18 UTC
Some notes below your chosen depth have not been shown here


No such thing as a small change
	PerlMonks