CaptainCsaba
Board Regular
- Joined
- Dec 8, 2017
- Messages
- 78
Hi!
I just wanted to ask whether it is possible to mimic googles IMPORTXML Function in Excel 2016. I know about the "From Web" queries on the Data tab. Could they be used in a way where they return multiple queries in the same spreadsheet?
What I mean is lets say that in column A I have 200 URLs. And In column be there is a queries or a formula that has the xpath in it that returns what i need from The link in column A. The Xpath is always the same, the only things that differ are the URLs. So I would have a URL in A1 and B' would use the URL and an XPATH to return the word that i need from the web. Is this possible with excels current functions or is there a macro designed for this purpose?
I just wanted to ask whether it is possible to mimic googles IMPORTXML Function in Excel 2016. I know about the "From Web" queries on the Data tab. Could they be used in a way where they return multiple queries in the same spreadsheet?
What I mean is lets say that in column A I have 200 URLs. And In column be there is a queries or a formula that has the xpath in it that returns what i need from The link in column A. The Xpath is always the same, the only things that differ are the URLs. So I would have a URL in A1 and B' would use the URL and an XPATH to return the word that i need from the web. Is this possible with excels current functions or is there a macro designed for this purpose?