Hi everyone, my name is A.Maurizio
My problem is this:
On an Excel sheet starting from cell (A5) to cell (E5) I have entered some items to get from a website called "Immobiliare.it"
the possibility of connecting to this site and obtaining results based on my research desires; And so far so good.
Now the problem is this:
When I start my procedure and the corresponding site opens
The code I put in takes me only the first three cells and puts them on the web page; but not the last two forms of research.
You would be able to help me solve this problem. Thanks
Greetings from A.Maurizio
Hi Maurizio,
Please supply your workbook so we can see your code.
Also, have you read these posts https://www.myonlinetraininghub.com/?s=scraping
Phil
Hi Philip
Sorry if I was unable to insert my file properly.
But I was having ADSL problems
Now fixed
Thank you for your intervention.
(P.S) Now I will gladly take a look also at your link to see if I can solve all my work by myself Thanks
Hi Maurizio,
So you want to go to this website:
Immobiliare.it/Affitto-Garage/Bologna/
and then get the price and area of each listing, for each page? To clarify that, when I look at the site now there are 154 results over 7 pages. You want information from all of these?
From the one line in your sample workbook I'm not sure exactly what data you are after. Can you please fill in a few lines of sample data showing exactly what you want.
Regards
Phil
Hi Philip how are you!
Listen to what I would like and simply manage to insert the data I write into the cells of the excel sheet which are (D5: D6) and (E5: E6) in the html page of the site just as you wrote:
Immobiliare.it/Affitto-Garage/Bologna/
in their section which is: (Price = D5: D6) and (Surface = E5: E6) That's all!
Thank you
By doing this every time I end my research
On the web page I have all the data to see the best offers.
Then it is clear that: what I would like to have, would be that for all my research, even the first 5 occasions that were displayed on the web could be recovered, but on the excel sheet; but this and a whole other thing that I will be able to see later?
Hello and thank you right now for all your advice and help you give me about it.
Greetings from A.Maurizio
Hi Maurizio,
Give this a go.
Regards
Phil
Hi Philip how are you!
Thanks for your help, and very nice in its simplicity.
But: You try to take a look at my latest work always for the "Immobiliare.it" site
So you not only understand what I meant by inserting data from excel to the web page
Now I just have to understand how to get even the first 5 offers of this paddle.
this time from the Web Page to the excel sheet.
That's all !
Thanks anyway for your interest; You are a Great.
Greetings from A.Maurizio
Hi Philip
Listen: Don't take this Problem into account anymore, as in some ways I solved it by doing this:
1) I found all the pieces to be inserted in the various cells which in turn then give me the green light to search on the web page.
2) It is true that I was unable to download everything on the excel sheet; But that's okay.
As I copy them directly from the web page and I stick them directly in the excel sheet, so I have always updated them.
Thanks again for your help and your commitment
Sincere Salut by A.Maurizio
You're welcome, glad you got it sorted out.
Phil
