my $cols_pos = 'c'; my $row = 3; my $selected_range = $Sheet->Range("a${row}:${cols_pos}${row}")->{Value}; $onerow = join (' ', @{$selected_range->[0]}); # 0 just because we know its only one row which we want