xml - IMPORTXML works in one Sheet but not in the other -


i have question. using importxml function in google sheet created , works fine.

=importxml("https://myurl.com","//div[@id='content']/div/span")

when paste code in sheet shared me error. owner of file gets error when tries. error formula parse error. nog tries load. when paste it, instantly changes error.

this code not working:

=importxml("https://en.wikipedia.org/wiki/moon_landing", "//a/@href")

from google page: https://support.google.com/docs/answer/3093342?hl=en

my question, why importxml work in 1 document, not in other.

thank you!

 =importxml("https://en.wikipedia.org/wiki/moon_landing"; "//a/@href") 

if owner of sheet has different locale settings, need change , ;


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -