in reply to Spreadsheet::XLSX Cell Access

Obligatory link: http://perl.plover.com/varvarname.html.

Use a hash:

my %yield;

$yield{$_} = $sheet->{"${_}35"} for "F".."K";
#or
$yield{$_} = $sheet->{ $_ . 35 } for "F".."K";

[download]

Replies are listed 'Best First'.
Re^2: Spreadsheet::XLSX Cell Access
by Hammer2001 (Novice) on Sep 13, 2013 at 00:10 UTC
    Runrig et el, thanks for your quick replies.

    Runrig, how do declare an array of hashes? In your snippet "my %yield;" will only declare a single hash whereas I need 6 of them.

    I can testify that

    my %pond$_ for "F".."K";

    does not work.

    Thanks,

    Hamid

[reply]

      Runrig et el, thanks for your quick responses. Runrig, how do I declare an array/series of hashes? In your snippet "my %yield;" will only declare a single hash whereas I need 6 of them.

      I can testify that

      my %pond$_ for "F".."K";

      does not work.

      Thanks,

      Hamid

      PS. Sorry for erroneously starting a new thread.

[reply]

        An array of hashes is declared as a simple array:

        my @pond;

        Then to use it, one possible way is this:

        $pond[$i]{$_} = 'foo';

        But from what you have shown, you only need a single hash as follows:

        $yield{$_} = 'bar';

        Read the link that has been provided to you in an earler post.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom