1

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/2rPDE000HV19H99

What i want is to pick up the 1st value which is right bellow this : FB/UCB WT 18

So by inspecting the page with Google Chrome, i find the right line and copy its XPath. It gives me that :

//*[@id="main-content"]/div/section/header/div/div/div[1]/div[1]/div/div[1]/span[1]

I go on my Google Sheet document, write this :

=IMPORTXML("https://www.boursorama.com/bourse/produits-de-bourse/cours/warrants/2rPDE000HV19H99";J57)

With inside J57 this :

//*[@id="main-content"]/div/section/header/div/div/div[1]/div[1]/div/div[1]/span[1]

But i'm getting no value :

#N/A

I need your help to fix the XPath problem, i don't know at all what's wrong with it, it is really annoying...

And asweel i'd like to know how to put put the XPath directly inside the command: i can't because of the " .

Thanks a lot.

My Google Sheet document

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.