xpath

The IMPORTXML formula for Google Sheets is "=IMPORTXML(Url, xpath_query)". For example webpage Amazing Spider-Man #365 Value - GoCollect, I've been trying to extract the data under "Preview Grades", specifically the FMV data per grade. I don't know what I'm doing wrong, but I can't figure out...

I am trying to find a good way to convert an HTML document to XML so I can use an Xpath expression for parsing. As a test I'd like to get this xpath expression to pull information from What Is My IP❓ Shows your real public IP address - IPv4 - IPv6 //*[@id="post-7"]/div[1]/div[1]/div/ul/li[2] So...

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...

Hello everybody (hello doctor nick) I'm a long time reader and follower first time posting. From this amazing community i was able to import multipul file names into excel. One down side was that sometimes i only need to select one file instead of the whole folder. I used the following code...

Hello everybody (hello doctor nick) I'm a long time reader and follower first time posting. From this amazing community i was able to import multipul file names into excel. One down side was that sometimes i only need to select one file instead of the whole folder. I used the following code...

I needed a quick fix to break out my worksheet tabs into separate files, so I found the code below. However, when it runs, it doesn't break anything out, it just saves one worksheet as "sheet1.xlsx". Here's the code that another user was kind enough to provide: (it came from: Copying/Saving...

I am trying to write code which will help me verify a very large number of XML files. Each of these XML files will have a corresponding XSD which will be provided with it. So far I was able to write code to create XMLMap, then set XPath (repeatable) of some fields to ranges, and then import the...

howdy this code, which loads a KML file, is working great. I'm getting the coordinates of the current oCustomNode: Sub Add_Traverse_CustomXMLPart() Dim oCustomPart As CustomXMLPart Dim oCustomNode As CustomXMLNode Dim oCustomNodes As CustomXMLNodes 'Add a Custom XML Part...