upload.rb

  def upload
    spreadsheet = Roo::CSV.new(params[:file].path, csv_options: {col_sep: "\t"})
    spreadsheet.inspect
    header = spreadsheet.row(1)
    (2..spreadsheet.last_row).each do |i|
      row = Hash[[header, spreadsheet.row(i)].transpose]
    end
    redirect_to root_url
  end