0

enter image description here Here is the image and I would like to retrieve the 6 numbers and import it to a Google Sheet.

  • Hey, did you try formulas like =IMPORTXML() ? – pjmg Oct 27 '20 at 9:00
0

For an example page with similar elements, you can use

=importxml("https://a0z1.github.io/test/num-gagnants.html","//span[contains(@class,'nums')]")

page with similar elements

    <!DOCTYPE html>
    <html>
    <head>
    <title>num-gagnants</title>
    <meta charset="UTF-8">
    </head>
    <body>
    <div id="num-gagnants">
      <span class="nums">10</span>
      <span class="nums">15</span>
      <span class="nums">16</span>
      <span class="nums">22</span>
      <span class="nums">25</span>
      <span class="nums">30</span>
    </div>
    </body>
    </html>

example html

  • Thank you, please advise me how can I learn such trick to perform better in my job as data analyst – Marvina Oct 28 '20 at 13:44

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.