Re^2: Unable to use Spreadsheet::ExcelHashtable module

Thank u very much, it worked for me, I want to retreive values from $excel_hash

for (keys %{$excel_hash}) { print "$_\n"; }

Above is printing the values but i am unable to interprete it properly..please explain me..

Comment on Re^2: Unable to use Spreadsheet::ExcelHashtable module Download Code

Replies are listed 'Best First'.
Re^3: Unable to use Spreadsheet::ExcelHashtable module by keszler (Priest) on Oct 25, 2011 at 11:28 UTC
`%{$excel_hash}`: treat the variable $excel_hash as a hash. perlreftut perlref perldsc `(keys %{$excel_hash})`: return a list of keys for the given hash. keys `for (keys %{$excel_hash}) {`: loop over the hash keys, setting `$_` (by default because no variable was given to `for`) to each key in turn. For Loops `for (keys %{$excel_hash}) { print "$_\n"; }`: print each hash key (note: not the value, just the key). `for (keys %{$excel_hash}) { print "key:$_ = $excel_hash->{$_}\n"; }`: print keys and values. For a complete view of the structure of $excel_hash, try: `use Data::Dumper; print Dumper($excel_hash);` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Unable to use Spreadsheet::ExcelHashtable module
by keszler (Priest) on Oct 25, 2011 at 11:28 UTC

%{$excel_hash}: treat the variable $excel_hash as a hash. perlreftut perlref perldsc
(keys %{$excel_hash}): return a list of keys for the given hash. keys
for (keys %{$excel_hash}) {: loop over the hash keys, setting $_ (by default because no variable was given to for) to each key in turn. For Loops
for (keys %{$excel_hash}) { print "$_\n"; }: print each hash key (note: not the value, just the key).
for (keys %{$excel_hash}) { print "key:$_ = $excel_hash->{$_}\n"; }: print keys and values.

For a complete view of the structure of $excel_hash, try:

use Data::Dumper;
print Dumper($excel_hash);
[download]

[reply]
[d/l]
[select]