0

I am trying to import a table from the lower part of the following website to Google Sheets: https://vistacapital.com.br/

I used the formula:

=IMPORTXML("https://vistacapital.com.br";"//*[@id='sos-vmf']/td[2]/text()")

but the output is empty.

I need the value underneath the word "cota", to the right of the word "Vista Multiestrategia FIM"

or import the entire table, with the bottom formula, but it no longer works:

=IMPORTHTML("https://vistacapital.com.br";"table";1)

Anyone help?

0

There is an error on the URL used on the formulas. Instead of

"https://.vistacapital.com.br"

try

"https://vistacapital.com.br"

  • it was not this, it is using correctly in the sheet. – Junior Jan 14 at 10:40
  • 1
    @Junior Please edit your question to show how the formula is in the sheet. – Rubén Jan 14 at 15:18
0

Unfortunately, you can't have those data, because they are injected into the table by JS. That's why when you use this formula, the table is empty:

=IMPORTHTML("https://vistacapital.com.br"; "TABLE"; 1)

All you can get is this:

=IMPORTXML("https://vistacapital.com.br"; "//*")
  • Unfortunately I do not have the field I need ("cota" value) – Junior Jan 14 at 10:38
  • @Junior "Unfortunately, you can't have those data..." – user0 Jan 14 at 10:47

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.