my $excel_input_file= 'c:\begperl\data.new.txt'; my $workbook = Excel::Writer::XLSX->new('c:\begperl\data.xlsx'); my $worksheet = $workbook->add_worksheet(); my $worksheet2 = $workbook->add_worksheet(); open( my $in2, '<', $excel_input_file) or die "Can't open $excel_input_file: $!"; open (my $out2, '>', $workbook) or die "Could not open file '$workbook' $!"; #put stuff that reads txt file numerical data into excel # each value separated by space goes in next column #each new line from txt file goes in next row #close up shop close $in; close $out;