GET ALL element from web table

[luca90]

https://www.paginebianche.it/cap/abruzzo/ch.htm

based this site , how to gell all value in table?

for example:
from:
Altino 66040
....
to:
Villamagna 66010

tks!

 

[AliGW]

If you try using Power Query, you get this:

Access to this source is forbidden.

so you can't crawl for data - it's blocked to prevent it.

 

[Frank2021]

Hi @luca90 & @AliGW,

Here is the solution to extract all the data from the table on that webpage.
I have attached the complete Excel spreadsheet to this response, so you don't need to copy or paste any code yourself. Everything is pre-configured and ready to use!

How to use it:

1. Open the attached spreadsheet.
2. Make sure macros are enabled if Excel prompts you.
3. Simply click the "Run" button on the sheet.

The script will automatically connect to the live webpage, bypass the security layers using a targeted CSS selector (div.box-dis-cont), and pull all the municipalities along with their corresponding 5-digit postal codes (CAP) directly into your table within seconds.
If this spreadsheet helps you get all the values cleanly, please don't forget to hit the thumbs-up (upvote) button!

Thanks!

 

[luca90]

Hi @luca90 & @AliGW,

Here is the solution to extract all the data from the table on that webpage.
I have attached the complete Excel spreadsheet to this response, so you don't need to copy or paste any code yourself. Everything is pre-configured and ready to use!

How to use it:

1. Open the attached spreadsheet.
2. Make sure macros are enabled if Excel prompts you.
3. Simply click the "Run" button on the sheet.

The script will automatically connect to the live webpage, bypass the security layers using a targeted CSS selector (div.box-dis-cont), and pull all the municipalities along with their corresponding 5-digit postal codes (CAP) directly into your table within seconds.
If this spreadsheet helps you get all the values cleanly, please don't forget to hit the thumbs-up (upvote) button!

Thanks!


View attachment 91525

tks bro