Scrape images URLs from google images with VBA and put into excel
$10-30 USD
Selesai
Dibuat hampir 9 tahun yang lalu
$10-30 USD
Dibayar ketika dikirim
I need a routine in VBA using Excel for scraping urls into google search images.
In excel I have many rows: 1 row for 1 of my products.
In each row there is the product code, the product name and the name of the product image.
With the keys of the name of the product I build the link for search in google images web page.
For example:
with che product name: Royal Canin Satiety Support
I build the link for the search in this way
[login to view URL]:1,cd_min:01/02/2015,cd_max:11/04/2015,isz:m&tbm=isch
(In this link I consider also from date .... To date ... .. and medium images dimensions)
This for each row (each product).
The routine in VBA should:
- Open the url (eg see URL up)
- For each product (I can decide how many products I want to scrape) I have to fetch the URL of the image in google (Important: not the thumbnail image but the image that you can see clicking on the thumbnail).
- These URLs to the images scraped will be included in the columns on the right and on the same line of the corresponding product:
Example:
ProductCode - ProductName - [login to view URL] - URLimg01 - URLimg02 - URLimg03 .......
R064 - Royal Canin Satiety Support - [login to view URL] - URLimg01 - URLimg02 - URLimg03 .......
With a function of excel I display the corrisponding image from the different URLs downloaded (eg URLimg01 URLimg02 ....) (I have ASAP utilities and it is possible)
Then I choose the most appropriate image (only one) for each item (row of the spreadsheet): this is a manual work that I have to do
Then with the only images that interest me I have to be able to download from the Internet, put them on a directory and rename them with the name [login to view URL] (different for each line, and that is taken from the fields already present on the product).