for my $row($excel_configs->{custom_api_seq_sheet}{start_row}...$excel_configs->{custom_api_seq_sheet}{end_row}-2){ foreach my $col (1..$excel_configs->{custom_api_seq_sheet}{end_col} -1){ if($Sheet->Cells($row,$col)->{'Value'} eq Link){ print $Sheet->Cells($row,$col)->Hyperlinks()->Address."\n"; $api_table->{$api_count}{$table_order->{$col}} = $Sheet->Cells($row,$col)->Hyperlinks->{Address}; }