from selenium import webdriver
from selenium.webdriver.chrome.service import Service
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.common.by import By
from selenium.webdriver.support.wait import WebDriverWait
import xlwt
from xlwt import Workbook
import mouse
import time
import xlrd
i = 1
allgropath = "https://allegro.pl/listing?string="
order = "&order=p"
s: Service = Service('C://webdriver/chromedriver.exe')
driver = webdriver.Chrome(service=s)
wb = Workbook()
sheet1 = wb.add_sheet('ceny allegro')
driver.get('https://allegro.pl/listing?string=5901738907737&order=p')
driver.maximize_window()
driver.implicitly_wait(5)
mouse.move(550, 1000, absolute=True, duration=1.8)
mouse.click()
mouse.move(750, 500, absolute=True, duration=1.8)
time.sleep(2)
mouse.click()
time.sleep(8)
search = driver.find_element(By.CLASS_NAME, '_7030e_1tOgC')
sheet1.write(1, 0, search.text)
while i <= 6:
PATH = 'exel\ean.xls' #####path do exela
exel = xlrd.open_workbook(PATH) ##### otweiranie exela do zmiennej
exel_sheet1 = exel.sheet_by_index(0) ####otwieranie sheetu index = 0
exel_value = exel_sheet1.cell_value(1 + i, 0) #####wiersze,kolumny
exel_url = allgropath + exel_value + order
driver.get(exel_url)
mouse.move(750, 650, absolute=True, duration=1.8)
time.sleep(2)
mouse.click()
search = driver.find_element(By.CLASS_NAME, '_7030e_1tOgC')
sheet1.write(1 + i, 0, search.text)
i += 1
time.sleep(8)
wb.save('test.xls')
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}