import unittest
from selenium import webdriver
from openpyxl import load_workbook
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support import ui

filepath = "/home/aj/Desktop/LORIELLE.xlsx"
wb=load_workbook(filepath)
sheet=wb.active
rowCount = sheet.max_row

browser = webdriver.Chrome("/usr/lib/chromium-browser/chromedriver")
browser.get('https://ischo.searcaapps.org')

user = browser.find_element_by_id('username')
user.send_keys('lavm')
password = browser.find_element_by_id('password')
password.send_keys('lavm@1234')
password.send_keys(Keys.ENTER)


browser.get('https://ischo.searcaapps.org/ischo/scholarship/?d=all&p=40&fr=2019&to=2021')

userTable = browser.find_element_by_id('listTable')
rowVals = userTable.find_elements_by_tag_name('tr')
rowNum = len(browser.find_elements_by_xpath('/html/body/section/article/table/tbody/tr'))

i = 2
currentName = browser.find_element_by_xpath("//tr[" + str(i) + "]//td[2]").text
browser.find_element_by_link_text(currentName).click()
browser.find_element_by_link_text('Edit').click()
for j in range(1, rowCount):
    if currentName == sheet.cell(row=j, column=6).value:
        currentRowExcel = j

# NAMEOFCOLLEGE/UNIVERSITY
browser.find_element_by_name('college[]').send_keys(Keys.CONTROL + 'a')
browser.find_element_by_name('college[]').send_keys(Keys.DELETE)
collegeName = sheet.cell(row=currentRowExcel, column=16).value