Advertisement
arvingarciaa

Untitled

Jan 31st, 2020
3,556
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 3.17 KB | None | 0 0
  1.   # CLICK NEXT PAGE
  2.         browser.find_element_by_link_text('Next').click()
  3.  
  4.         time.sleep(10)
  5.         # NAMEOFCOLLEGE/UNIVERSITY
  6.         browser.find_element_by_name('college[]').clear()
  7.         browser.find_element_by_name('univcountry[]').clear()
  8.         collegeName = sheet.cell(row=currentRowExcel, column=16).value
  9.         if collegeName is not None:
  10.             if collegeName.lower() == 'uplb':
  11.                 browser.find_element_by_name('college[]').send_keys('University of the Philippines Los Baños (UPLB)')
  12.                 browser.find_element_by_name('univcountry[]').send_keys('Philippines')
  13.             elif collegeName.lower() == 'ku':
  14.                 browser.find_element_by_name('college[]').send_keys('Kasetsart University (KU)')
  15.                 browser.find_element_by_name('univcountry[]').send_keys('Thailand')
  16.             elif collegeName.lower() == 'upm':
  17.                 browser.find_element_by_name('college[]').send_keys('Universiti Putra Malaysia (UPM)')
  18.                 browser.find_element_by_name('univcountry[]').send_keys('Malaysia')
  19.             elif collegeName.lower() == 'ipb':
  20.                 browser.find_element_by_name('college[]').send_keys('Institut Pertanian Bogor (IPB)')
  21.                 browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
  22.             elif collegeName.lower() == 'ugm':
  23.                 browser.find_element_by_name('college[]').send_keys('Universitas Gadjah Mada (UGM)')
  24.                 browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
  25.             elif collegeName.lower() == 'ub':
  26.                 browser.find_element_by_name('college[]').send_keys('Universitas Brawijaya (UB)')
  27.                 browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
  28.             elif collegeName.lower() == 'clsu':
  29.                 browser.find_element_by_name('college[]').send_keys('Central Luzon State University (CLSU)')
  30.                 browser.find_element_by_name('univcountry[]').send_keys('Philippines')
  31.             elif collegeName.lower() == 'tokyo-nodai':
  32.                 browser.find_element_by_name('college[]').send_keys('Tokyo-Nodai University')
  33.                 browser.find_element_by_name('univcountry[]').send_keys('Japan')
  34.             elif collegeName.lower() == 'rac':
  35.                 browser.find_element_by_name('college[]').send_keys('Royal Agricultural University')
  36.                 browser.find_element_by_name('univcountry[]').send_keys('England')
  37.             elif collegeName.lower() == 'asog':
  38.                 browser.find_element_by_name('college[]').send_keys('Ateneo de Manila University (ADMU)')
  39.                 browser.find_element_by_name('univcountry[]').send_keys('Philippines')
  40.             elif collegeName.lower() == 'upv':
  41.                 browser.find_element_by_name('college[]').send_keys('University of the Philippines Visayas (UPV)')
  42.                 browser.find_element_by_name('univcountry[]').send_keys('Philippines')
  43.             elif collegeName.lower() == 'unigott':
  44.                 browser.find_element_by_name('college[]').send_keys('University of Goettingen')
  45.                 browser.find_element_by_name('univcountry[]').send_keys('Germany')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement