in reply to Re^10: Converting Excel to Hash
in thread Converting Excel to Hash

You need to create a new %set hash for each row

##my %set =(); <- move this line inside loop my %data =(); my ($r,$val,$master_key); for my $row (1 .. $eSheet->{MaxRow}){ my %set =(); # <- move to here ..
poj

Replies are listed 'Best First'.
Re^12: Converting Excel to Hash
by ravi179 (Novice) on Jan 05, 2017 at 08:48 UTC

    Thank you .It worked for me.