Python - Selenium Sample

준비

# use chromedriver
# pip install selenium
import time
from selenium import webdriver
import datetime
import os
# Browser Option
# options = webdriver.ChromeOptions()
# options.add_argument('headless')
# options.add_argument('window-size=1920x1080')  # 브라우저 사이즈 결정
# options.add_argument("disable-gpu")
# make Dir
down_folder = r"C:\원하는경로"
if not os.path.isdir(down_folder) : 
    os.mkdir(down_folder)
# Get Driver Url
options = webdriver.ChromeOptions()
options.add_argument("disable-gpu")
options.add_argument("lang=ko_KR")
options.add_experimental_option("prefs", {
  "download.default_directory": r"C:\원하는경로", # 원하는경로로 다운로드 폴더 변경
  "download.prompt_for_download": False,
  "download.directory_upgrade": True,
  "safebrowsing.enabled": True
})
driver = webdriver.Chrome(r"C:\웹드라이버설치경로\chromedriver.exe", chrome_options=options)
driver.get("https://URL")       
# Put Login Data
time.sleep(0.1)
#driver.find_element_by_name('admin_id').send_keys('online_test')
driver.find_element_by_name('admin_id').send_keys('아이디값')
time.sleep(0.1)
#driver.find_element_by_name('admin_pwd').send_keys('dhsfkdls')
driver.find_element_by_name('admin_pwd').send_keys('패스워드값')
# Login Click
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="admin_login"]/form/input[5]').click()
# Move Page
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="adminHeader"]/div[2]/nav/ul/li[3]/a').click()
# Detail Click
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="searchCtl"]').click()
# Detail Option Setting
# Option Set
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="search"]/table/tbody/tr[1]/td/select/option[5]').click()
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="search"]/table/tbody/tr[2]/td/ul[1]/li[5]/label').click()
# Set Date
time.sleep(0.1)
today =datetime.datetime.now()
yesterday = today - datetime.timedelta(1)
rDay = yesterday.strftime("%Y-%m-%d")
time.sleep(0.5)
driver.find_element_by_name('start_date').clear()
time.sleep(0.1)
# driver.find_element_by_name('start_date').send_keys('2021-01-21')
driver.find_element_by_name('start_date').send_keys(rDay)
time.sleep(0.5)
driver.find_element_by_name('finish_date').clear()
time.sleep(0.1)
# driver.find_element_by_name('finish_date').send_keys('2021-01-21')
driver.find_element_by_name('finish_date').send_keys(rDay)
# Submit
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="search"]/div[2]/span[1]/input').click()
# Excel Download
time.sleep(2.5)
driver.find_element_by_xpath('//*[@id="ordSearchFrm"]/div[2]/div/span[1]/input').click()
# Excel Option 
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="excelLayer"]/table/tbody/tr[1]/td/select/option[4]').click()
#driver.find_element_by_xpath('//*[@id="excelLayer"]/table/tbody/tr[1]/td/select/option[9]').click()
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="excelLayer"]/table/tbody/tr[3]/td/label[2]/input').click()
# Finish
time.sleep(0.1)
driver.find_element_by_xpath('//*[@id="excelLayer"]/div/span[1]/input').click()
# Rename
time.sleep(2)
todayName = "order_list" + today.strftime("%Y%m%d") + ".xls"
rTodayName = today.strftime("%Y%m%d") + " 파일 다운로드.xls"
oName = r"C:\\원하는경로\\"
rName = oName + todayName
tName = oName + rTodayName
os.rename(rName, tName)
# Close
time.sleep(7)
driver.close()