Google Sheets - index importxml doesn't work

xml xpath google-sheets google-sheets-formula

I wanted to make a sheet with information about companies, but unfortunately, impossible to do so.

However, I don't know what else I can do, I followed the instructions in the documentation to the letter:

  • I have the URL : https://www.stockopedia.com/share-prices/EPA:GET/

  • I have the XPath of the element I want: enter image description here

(I even made two versions, one with " " and another with ' '), or with the "full XPath" and nothing works, I don't see what else I can do...

  • //*[@id="__next"]/main/div/div[2]/div[4]/div/div[1]/div/div[2]/dl/dd[1]/a
  • //*[@id='__next']/main/div/div[2]/div[4]/div/div[1]/div/div[2]/dl/dd[1]/a
  • /html/body/div[1]/main/div/div[2]/div[4]/div/div[1]/div/div[2]/dl/dd[2]/a

enter image description here

Can you help me ?


Solution 1:

You will use the single quotes within the double quotes.

I had success with

=IMPORTXML("https://www.stockopedia.com/share-prices/EPA:GET/","//*[@id='__next']/main/div/div[2]/div[4]/div/div[1]/div/div[2]/dl/dd[1]/a")

Example sheet here.

Related

Error when converting image to black and white for OpenCV facial detection [duplicate]
Rename file using xargs -a file
print a filled square in console
Python JSON Sorting nested data
"HTTPError: HTTP Error 404: Not Found" while using translation function in TextBlob
extconf failed, exit code 1 error when installing [Ruby on Rails] 5 on OS X Yosemite 10.10.5
Different data types for time
Ruby/Rails convert string to JSON -> JSON.parse produces JSON::ParserError
What is the most efficient way to rank the item of a list based on the preference of the user by showing two item at a time?
SAS Export multiple datasets in work folder to multiple Excel workbooks with same names as datasets
How to programmatically connect to Wifi with no internet Android (Xamarin)
How to select just one id from a set of repetitive records in SQL and select only one of the corresponding values