http://qs1969.pair.com?node_id=1053818


in reply to Re^2: Spreadsheet::XLSX Cell Access
in thread Spreadsheet::XLSX Cell Access

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.

Replies are listed 'Best First'.
Re^4: Spreadsheet::XLSX Cell Access
by Laurent_R (Canon) on Sep 13, 2013 at 06:18 UTC

    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.