Excel VBA: Scraping HTML data behind script

Question

I have this HTML, and I'm trying scrape the values behind data-v-88f004c6 after "Compra:" and after "Venta:"

<div class="info-tc" data-v-88f004c6>
  <span data-v-88f004c6>Tipo de cambio del dólar hoy en Perú</span>   
  <span data-v-88f004c6>
    <i aria-hidden="true" class="fa fa-info-circle i-help" data-v-88f004c6></i>
  </span>
  <span data-v-88f004c6>Compra: 
    <strong data-v-88f004c6></strong>
  </span>
  <span data-v-88f004c6>Venta: 
    <strong data-v-88f004c6></strong>
  </span>
</div>

When I bring up the developer tools from Chrome I can see that the values appear like this (3.199 and 3.237):

<div class="info-tc" data-v-88f004c6="">
  <span data-v-88f004c6="">Tipo de cambio del dólar hoy en Perú</span>&nbsp;&nbsp;&nbsp;
  <span data-v-88f004c6="">
    <i aria-hidden="true" class="fa fa-info-circle i-help" data-v-88f004c6=""></i>&nbsp;
  </span>
  <span data-v-88f004c6="">Compra:&nbsp;
    <strong data-v-88f004c6="">3.199</strong>
  </span>&nbsp;&nbsp;
  <span data-v-88f004c6="">Venta:&nbsp;
    <strong data-v-88f004c6="">3.237</strong>
  </span>
</div>

However when I scrape the values using Excel I get symbols like this for the prices.

Tipo de cambio del dÃ³lar hoy en PerÃºÂ Â Â Â Compra:Â Â Â Venta:Â

I'm using a code like this to scrape the web:

    Set GetRawHTML = New HTMLDocument
    With CreateObject("WINHTTP.WinHTTPRequest.5.1")
        .Open "GET", urlWebSite, False
        .send
        GetRawHTML = .responseText
    End With
    kambistafx = GetRawHTML.body.innerHTML
    fxprice = kambistafx .getElementsByClassName("info-tc").Item(0).innerText

What should I do to scrape those values?

Are you trying to get the table containing those value you have mentioned in your post? Have you tried using IE? — SIM
– SIM, Commented Mar 26, 2018 at 18:28
IE is another method for scraping data from Excel? I haven't tried it. But it's weird that function doesn't work, it's the first time I have a problem with it. — capm
– capm, Commented Mar 26, 2018 at 20:37
It's the first time for you to encounter such trouble because you never scraped any dynamically generated items. However, be it winhttp, xmlhttp, or serverxmlhttp, they can't handle javascript heavy items. So, the best choice for you in this case is to choose any browser simulator. — SIM
– SIM, Commented Mar 27, 2018 at 4:04

QHarr · Accepted Answer · 2018-06-08 09:04:55Z

1

I did this with selenium basic

CSS selectors

#__layout span:nth-child(2) +*") 'compra
#__layout span:nth-child(3) +*") 'venta

These are contracted versions of full selectors which were:

#__layout > div > main > section.banner > div.central-section > div.col.paddingTop2 > section > div > span:nth-child(2) > strong
#__layout > div > main > section.banner > div.central-section > div.col.paddingTop2 > section > div > span:nth-child(3) > strong

Example CSS query:

Source page values

Code:

Option Explicit
Public Sub GetInfoSel()
    Dim d As WebDriver, keys As New keys
    Set d = New ChromeDriver
    Const URL = "https://kambista.com/"

    With d
        .Start "Chrome"
        .Get URL
          Debug.Print .FindElementByCss("#__layout span:nth-child(2) +*").Text 'compra
          Debug.Print .FindElementByCss("#__layout span:nth-child(3) +*").Text  'venta
        .Quit
    End With
End Sub

Note:

After installing Selenium basic and opening excel you need to add a reference via VBE > Tools > References > Selenium type library

answered Jun 8, 2018 at 9:04

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

QHarr Over a year ago

Hi, Did you try this please? I went to the effort of answering it for you.

capm Over a year ago

Yes, but not on my work terminal. I can't install selenium on that computer.

Collectives™ on Stack Overflow

Excel VBA: Scraping HTML data behind script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related