gistfile1.txt

# Helper methods defined here can be accessed in any controller or view in the application

Emparse.helpers do
  def logindata(login, password, spreadkey)    
    session = GoogleSpreadsheet.login(login, password)
    ws = session.spreadsheet_by_key(spreadkey).worksheets[0]
    fname = []
    lname = []
    address = []
    for row in 2..ws.num_rows
      fname[row] = ws[row, 1].downcase.strip
      lname[row] = ws[row, 2].downcase.strip
      address[row] = ws[row, 5].sub('www.', '')
      puts "#{fname[row]}.#{lname[row]}@#{address[row]}"
      puts "#{fname[row]}@#{address[row]}"
      puts "#{lname[row]}.#{fname[row]}@#{address[row]}"
    end
 
  end  
end