CaptainCsaba
Board Regular
- Joined
- Dec 8, 2017
- Messages
- 78
Hey!
Google sheets has a function called ImportXML, basically you give a URL and an Xpath and it automatically return that part of the website. It is a great feature however you can only use it for a few cells. My question is that is there a way to achieve this in excel 2016? I know about Webservice and FilterXML but they only work with RSS feed and the site I would want to use this on does not have that. i can see that there is an XML tab on the Developer tab but I don't really get it how it works. i would have to include a lot of it on a spreadsheet, probably around 10000, is this achievable? So my question is that is there a way to do they same with a formula or macro? To give a URL and an Xpath in excel for it to return part of a website?
Google sheets has a function called ImportXML, basically you give a URL and an Xpath and it automatically return that part of the website. It is a great feature however you can only use it for a few cells. My question is that is there a way to achieve this in excel 2016? I know about Webservice and FilterXML but they only work with RSS feed and the site I would want to use this on does not have that. i can see that there is an XML tab on the Developer tab but I don't really get it how it works. i would have to include a lot of it on a spreadsheet, probably around 10000, is this achievable? So my question is that is there a way to do they same with a formula or macro? To give a URL and an Xpath in excel for it to return part of a website?