Python 下载amazon 主图图片

测试积点老人

1. 
   
2. import requests
   
3. import xlwings
   
4. from selenium import webdriver
   
5. 
   
6. def download_image(image_url,ASIN):
   
7.     #下载图片
   
8.     resp = requests.get(image_url, headers=headers)
   
9.     file_path = 'E:/Download/BASIN/' + ASIN + '.jpg'
   
10.     with open(file_path,'wb') as f:
    
11.         f.write(resp.content)
    
12. 
    
13. def get_image_url(ASIN):
    
14.     #获得图片地址
    
15.     url = 'https://www.amazon.com/dp/' + ASIN
    
16.     browser.get(url)
    
17.     img_element = browser.find_element_by_xpath('.//div[@id="imgTagWrapperId"]/img')
    
18.     image_url = img_element.get_attribute('data-old-hires')
    
19.     return image_url
    
20. 
    
21. app = xlwings.App()
    
22. wb = app.books.open('E:/Download/BASIN/Casin.xlsx')
    
23. ws = wb.sheets('1')
    
24. ASINS = ws.range('a2:a3').value #打开excel文件读取需要爬取主图的asin
    
25. browser = webdriver.Chrome()
    
26. headers = {
    
27.     'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36',
    
28. }
    
29. image_news = []
    
30. for ASIN in ASINS:
    
31.     print(ASINS.index(ASIN)+1, ASIN)
    
32.     try:
    
33.         image_url = get_image_url(ASIN)
    
34.         download_image(image_url,ASIN)
    
35.         image_news.append('已下载')
    
36.     except:
    
37.         image_news.append('没找到')
    
38. 
    
39. ws.range('g2').options(transpose=True).value = image_news #在g列写下下载结果
    
40. wb.save()
    
41. app.quit()
    
42. browser.close()

复制代码

上面的代码是我复制别人的来改的 就是改了文件路径
下面是报错提示

1. D:\Users\TY\AppData\Local\Programs\Python\Python310\python.exe C:/Users/TY/PycharmProjects/pythonProject5/main.py
   
2. Traceback (most recent call last):
   
3. File "C:\Users\TY\PycharmProjects\pythonProject5\main.py", line 22, in
   
4. ws = wb.sheets('1')
   
5. File "D:\Users\TY\AppData\Local\Programs\Python\Python310\lib\site-packages\xlwings\main.py", line 4893, incall
   
6. return Sheet(impl=self.impl(name_or_index))
   
7. File "D:\Users\TY\AppData\Local\Programs\Python\Python310\lib\site-packages\xlwings_xlwindows.py", line 877, in call
   
8. return Sheet(xl=self.xl(name_or_index))
   
9. File "D:\Users\TY\AppData\Local\Programs\Python\Python310\lib\site-packages\xlwings_xlwindows.py", line 208, in call
   
10. v = self._inner(*args, **kwargs)
    
11. File "C:\Users\TY\AppData\Local\Temp\gen_py\3.10\00020813-0000-0000-C000-000000000046x0x1x9.py", line 36625, incall
    
12. ret = self.oleobj.InvokeTypes(0, LCID, 2, (9, 0), ((12, 1),),Index
    
13. pywintypes.com_error: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147352565), None)

复制代码

进程已结束,退出代码1

ASIN在表格sheet1种
有没有人帮我改下啊 谢谢

郭小贱

加油！

qqq911

看是否是路径问题

jingzizx

单步调呗

kallinr

这个男