Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # CLICK NEXT PAGE
- browser.find_element_by_link_text('Next').click()
- time.sleep(10)
- # NAMEOFCOLLEGE/UNIVERSITY
- browser.find_element_by_name('college[]').clear()
- browser.find_element_by_name('univcountry[]').clear()
- collegeName = sheet.cell(row=currentRowExcel, column=16).value
- if collegeName is not None:
- if collegeName.lower() == 'uplb':
- browser.find_element_by_name('college[]').send_keys('University of the Philippines Los Baños (UPLB)')
- browser.find_element_by_name('univcountry[]').send_keys('Philippines')
- elif collegeName.lower() == 'ku':
- browser.find_element_by_name('college[]').send_keys('Kasetsart University (KU)')
- browser.find_element_by_name('univcountry[]').send_keys('Thailand')
- elif collegeName.lower() == 'upm':
- browser.find_element_by_name('college[]').send_keys('Universiti Putra Malaysia (UPM)')
- browser.find_element_by_name('univcountry[]').send_keys('Malaysia')
- elif collegeName.lower() == 'ipb':
- browser.find_element_by_name('college[]').send_keys('Institut Pertanian Bogor (IPB)')
- browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
- elif collegeName.lower() == 'ugm':
- browser.find_element_by_name('college[]').send_keys('Universitas Gadjah Mada (UGM)')
- browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
- elif collegeName.lower() == 'ub':
- browser.find_element_by_name('college[]').send_keys('Universitas Brawijaya (UB)')
- browser.find_element_by_name('univcountry[]').send_keys('Indonesia')
- elif collegeName.lower() == 'clsu':
- browser.find_element_by_name('college[]').send_keys('Central Luzon State University (CLSU)')
- browser.find_element_by_name('univcountry[]').send_keys('Philippines')
- elif collegeName.lower() == 'tokyo-nodai':
- browser.find_element_by_name('college[]').send_keys('Tokyo-Nodai University')
- browser.find_element_by_name('univcountry[]').send_keys('Japan')
- elif collegeName.lower() == 'rac':
- browser.find_element_by_name('college[]').send_keys('Royal Agricultural University')
- browser.find_element_by_name('univcountry[]').send_keys('England')
- elif collegeName.lower() == 'asog':
- browser.find_element_by_name('college[]').send_keys('Ateneo de Manila University (ADMU)')
- browser.find_element_by_name('univcountry[]').send_keys('Philippines')
- elif collegeName.lower() == 'upv':
- browser.find_element_by_name('college[]').send_keys('University of the Philippines Visayas (UPV)')
- browser.find_element_by_name('univcountry[]').send_keys('Philippines')
- elif collegeName.lower() == 'unigott':
- browser.find_element_by_name('college[]').send_keys('University of Goettingen')
- browser.find_element_by_name('univcountry[]').send_keys('Germany')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement