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.
10
questions with no upvoted or accepted answers
2
votes
0answers
785 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
21 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
87 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
93 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
0answers
136 views
Pull “Fair Value” from Yahoo Finance to Google Sheet using XPath?
Currently, I am using xPath to grab Ex-Div date, Dividends, etc but I cannot seem to be able to grab the Fair Value "Undervalue" rating from Yahoo Finance.
I want the "Undervalue" to be specific but ...
0
votes
0answers
99 views
xPath_query from IMPORTXML in Google sheets ends up empty
So, in these covid19-infested days I want to update our digital signage with the current situation. Want to use google sheets and IMPORTXML to fetch data from a website that is frequently updated with ...
0
votes
1answer
472 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
165 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
167 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=...