Combine multiple sheets on xls into a single csv

combine.rb

require 'rubygems'
require 'roo'
require 'iconv'

oo = Excel.new("data.xls")

CSV.open("export.csv", "wb") do |csv|
  oo.sheets.each do |s|
    oo.default_sheet = s

    2.upto(oo.last_row) do |i|
        csv << (1..6).map {|j| oo.cell(i, j)}
    end

  end
end