People who code: we want your input. Take the Survey

Questions tagged [xpath]

XPath is a language for addressing parts of an XML document that can be used by some web apps like Google Sheets to import structured data.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
851 views

My ImportXML with XPath doesn't work

I've got a problem. I'm trying to import data in my google sheet document using =ImportXML with XPath from this page : https://www.boursorama.com/bourse/produits-de-bourse/cours/warrants/...
1
vote
0answers
77 views

Function always parses column in first row but would like it to repeat

I am trying to make a function that repeats in each row of a column that fetches the URL in the first column, does an xpath query and gets an image. Currently its all working other than the fact it ...
0
votes
0answers
26 views

Google Sheet Importxml did not work with div shown after I click button

I tried to extract Google Map link from web site using Importxml function of Google Sheet, anyway the data will show up after I click a button as picture below ( the div will show after I click a ...
0
votes
0answers
156 views

Data Scrape to Google Sheets from MyFitnessPal.com

I would like to be able to pull the macronutrient (and more if possible) data from MyFitnessPal using what i assume would need to be an importhtml() or importxml() function directly onto a google ...
0
votes
0answers
126 views

How to separate direct sibling elements into different columns?

So basically I'm trying to import a list of values from a certain web-page into my spreadsheet and I'm stuck. I want to make a list of names with their corresponding number stages next to them, all ...
0
votes
1answer
719 views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...
-1
votes
1answer
187 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
-1
votes
2answers
186 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...