Re^3: How to convert Excel contents into a hash table and further access the contents of that hash table ?

for my $row (1 .. $worksheet->row_range) {
    my $super_key = $worksheet->get_cell ($row, 0)->value;
    for my $col (0 .. 4) {
        my $key   = $worksheet->get_cell (0,    $col)->value;
        my $value = $worksheet->get_cell ($row, $col)->value;
        # here I am getting a problem #
        $student_data{$super_key}->{$key} = $value;
        }
    }
[download]

I am pretty sure the error if from either of the two lines above that. get_cell (...) will return undef for undefined cells, for which you cannot use the value method.

Enjoy, Have FUN! H.Merijn

Comment on Re^3: How to convert Excel contents into a hash table and further access the contents of that hash table ? Select or Download Code