require 'rubygems' require 'spreadsheet' book = Spreadsheet.open('Packungen.xls') sheet= book.worksheet(0) size = [] sheet.column(11).each do |x| size << x end unit = [] sheet.column(12).each do |x| unit << x end size_string = [] size.each_with_index do |s,i| size_string << s.to_s + " " + unit[i].to_s end size_string.each do |s| puts s end