Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,261
Worf submitted a new Excel article:
Mapping HTML trees with VBA - This article shows how to list parents and children that form the structure of Web pages.
Read more about this Excel article...
Mapping HTML trees with VBA - This article shows how to list parents and children that form the structure of Web pages.
When performing Web scraping, sometimes it is necessary to analyse how the page was constructed. Here are the main features of this post:
- Lists the XPath for all pairs of parent and child for a local HTML test file.
- Informs how many levels the page has and the tag for each element.
- When tested with an actual Web page(www.mrexcel.com), it totalized 339 elements arranged on 12 levels.
View attachment 69228...
Read more about this Excel article...