import requests
from bs4 import BeautifulSoup
import openpyxl
fpath = r'C:\pythonex\경쟁률_1.xlsx'
wb = openpyxl.load_workbook(fpath)
ws = wb.active
codes = [
'Sl5KTCVDYXwwOExKclc6L0pmZlRm','Sl5KTjlKclc6L0pmZlRm','Sl5KVyVNOWFhOUpyVzovSmZmVGY=','Sl5KOk0mSnJXOi9KZmZUZg==','Sl5KMDpXJkpyVzovSmZmVGY=','Sl5KYDpXJkpyVzovSmZmVGY=','Sl5KOk4mSnJXOi9KZmZUZg==','Sl5KOjhMSnJXOi9KZmZUZg==','Sl5KVyV8JnJXYXxMSnJXOi9KZmZUZg==','Sl5KYGJyOnxMSnJXOi9KZmZUZg==','Sl5KOkxMJUpyVzovSmZmVGY=','Sl5KTThXclc4OUpyVzovSmZmVGY=','Sl5KVyUvYDhWSnJXOi9KZmZUZg==','Sl5KOjBDSnJXOi9KZmZUZg==','Sl5KOjAmSnJXOi9KZmZUZg==','Sl5KVyUmclc4L0M6YWAmSnJXOi9KZmZUZg==','Sl5KV2FOOiZKclc6L0pmZlRm','Sl5Kclc4Ylc4SnJXOi9KZmZUZg==','Sl5KVyVyV2FiSnJXOi9KZmZUZg==','Sl5KOjBpSnJXOi9KZmZUZg==','Sl5KOmk5SnJXOi9KZmZUZg==','Sl5KJWAmVzh8SnJXOi9KZmZUZg==','Sl5Kclc6Jmk6YnxKclc6L0pmZlRm','Sl5KcldhVlc4TjlKclc6L0pmZlRm','Sl5KV2FOclc4OUpyVzovSmZmVGY=','Sl5KV2FOclc4OUpyVzovSmZmVGY=','Sl5KJS9yVzgmSnJXOi9KZmZUZg==','Sl5KZiVgJldhYkpyVzovSmZmVGY=','Sl5KOENDOHxKclc6L0pmZlRm','Sl5KTWJDQzh8SnJXOi9KZmZUZg==','Sl5KOlY5SnJXOi9KZmZUZg==','Sl5KMGE5OUpyVzovSmZmVGY=','Sl5Kclc6Yk1gJkpyVzovSmZmVGY=','Sl5KOi9yV2FgfExKclc6L0pmZlRm','Sl5KcldhL2AmOzhgfWE5SnJXOi9KZmZUZg==','Sl5KOnJySnJXOi9KZmZUZg==','Sl5KOld9YTlKclc6L0pmZlRm','Sl5KQzphYCZNOFdKclc6L0pmZlRm','Sl5KOkJKclc6L0pmZlRm','Sl5KZjpNJkpyVzovSmZmVGY=','Sl5KV2FhTVc6JkpyVzovSmZmVGY=','Sl5KfEwmSnJXOi9KZmZUZg==','Sl5KV2FhTnJXOnxMSnJXOi9KZmZUZg==','Sl5KfExgMDhgfWE5SnJXOi9KZmZUZg==','Sl5KOkxpSnJXOi9KZmZUZg==','Sl5KcldhJmFhTkpyVzovSmZmVGY=','Sl5KJjowQjlKclc6L0pmZlRm','Sl5KOmlNSnJXOi9KZmZUZg==','Sl5Kclc4TjlXYU5Kclc6L0pmZlRm','Sl5KOldCL0pyVzovSmZmVGY=','Sl5KOi9XYWAvSnJXOi9KZmZUZg==','Sl5KOlclfCZyV2FWSnJXOi9KZmZUZg==','Sl5KOkxNSnJXOi9KZmZUZg==','Sl5KYWk5YU1Kclc6L0pmZlRm','Sl5KV2F8TFc6JkpyVzovSmZmVGY=','Sl5Kclc4VmF8TEpyVzovSmZmVGY=','Sl5KYDY6L3JXOE45SnJXOi9KZmZUZg==','Sl5KOk45SnJXOi9KZmZUZg==','Sl5KOkJNOFdKclc6L0pmZlRm','Sl5KVzomYXxMSnJXOi9KZmZUZg==','Sl5KOi9yV2FgYnJKclc6L0pmZlRm','Sl5KfGFNOjlKclc6L0pmZlRm','Sl5KV2FgfExNJXJKclc6L0pmZlRm','Sl5KOjgwSnJXOi9KZmZUZg==','Sl5KZjk6cnJXYVZKclc6L0pmZlRm','Sl5KcldhVlc4SnJXOi9KZmZUZg==','Sl5KOmJKclc6L0pmZlRm','Sl5KYDpMSnJXOi9KZmZUZg==','Sl5KTCZMSnJXOi9KZmZUZg==','Sl5KOk05SnJXOi9KZmZUZg==','Sl5KYDpXVkpyVzovSmZmVGY=','Sl5KJjlKclc6L0pmZlRm','Sl5KVyUmYTlKclc6L0pmZlRm','Sl5KOmBWSnJXOi9KZmZUZg==','Sl5KOiZiSnJXOi9KZmZUZg==','Sl5KOmFNOUpyVzovSmZmVGY=','Sl5KVzgmQzpKclc6L0pmZlRm','Sl5KOlc6L2AvSnJXOi9KZmZUZg==',
]
row = 2
for code in codes:
url = f"http://ratio.uwayapply.com/{code}"
response = requests.get(url)
html = response.text
soup = BeautifulSoup(html,'html.parser')
ratio = soup.select(".trFieldValue")
print(ratio)
ws[f'D{row}']
row = row + 70
wb.save(fpath)