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.
9
questions with no upvoted or accepted answers
1
vote
0answers
728 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
76 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
58 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
66 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
55 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
0answers
26 views
Creating a Table in Google Sheets from XML Output with Multiple Children Levels
How to create a table in Google Sheets from an XML output with multiple children levels?
I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here.
...
0
votes
1answer
242 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
130 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
135 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=...
