Facebook
From Paltry Penguin, 2 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 81
  1. from selenium import webdriver
  2. from selenium.webdriver.chrome.service import Service
  3. from selenium.webdriver.common.keys import Keys
  4. from selenium.webdriver.common.by import By
  5. from selenium.webdriver.support.wait import WebDriverWait
  6. import xlwt
  7. from xlwt import Workbook
  8. import mouse
  9. import time
  10. import xlrd
  11.  
  12. i = 1
  13. allgropath = "https://allegro.pl/listing?string="
  14. order = "&order=p"
  15.  
  16. s: Service = Service('C://webdriver/chromedriver.exe')
  17. driver = webdriver.Chrome(service=s)
  18. wb = Workbook()
  19. sheet1 = wb.add_sheet('ceny allegro')
  20.  
  21. driver.get('https://allegro.pl/listing?string=5901738907737&order=p')
  22. driver.maximize_window()
  23. driver.implicitly_wait(5)
  24. mouse.move(550, 1000, absolute=True, duration=1.8)
  25. mouse.click()
  26. mouse.move(750, 500, absolute=True, duration=1.8)
  27. time.sleep(2)
  28. mouse.click()
  29. time.sleep(8)
  30. search = driver.find_element(By.CLASS_NAME, '_7030e_1tOgC')
  31. sheet1.write(1, 0, search.text)
  32.  
  33. while i <= 6:
  34.     PATH = 'exel\ean.xls'  #####path do exela
  35.     exel = xlrd.open_workbook(PATH)  ##### otweiranie exela do zmiennej
  36.     exel_sheet1 = exel.sheet_by_index(0)  ####otwieranie sheetu index = 0
  37.     exel_value = exel_sheet1.cell_value(1 + i, 0)  #####wiersze,kolumny
  38.     exel_url = allgropath + exel_value + order
  39.     driver.get(exel_url)
  40.  
  41.     mouse.move(750, 650, absolute=True, duration=1.8)
  42.     time.sleep(2)
  43.     mouse.click()
  44.     search = driver.find_element(By.CLASS_NAME, '_7030e_1tOgC')
  45.     sheet1.write(1 + i, 0, search.text)
  46.     i += 1
  47.     time.sleep(8)
  48.  
  49. wb.save('test.xls')
  50.