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