Convert execl to gist

convert_excel_to_gist.rb

require 'spreadsheet'
require 'csv'

filename = 'excelsample'
file = File.expand_path(File.dirname(__FILE__) + "/" + filename + '.xls')

excel = Spreadsheet.open(file, 'rb')

CSV.open(filename + '.csv', 'wb') do |csv|
  excel.worksheets.each do |sheet|
    1.upto(sheet.row_count).each do |row_count|
      csv << sheet.row(row_count) unless sheet[row_count,0].nil?
    end
  end
end