How to get web data into Excel (case study with Rugby World Cup 2019 results data)

Поділитися
Вставка
  • Опубліковано 22 січ 2025

КОМЕНТАРІ • 8

  • @wayneedmondson1065
    @wayneedmondson1065 5 років тому +1

    Hi Chandoo.. great example of the power and versatility of Power Query.. not to mention the fun of getting live data on your favorite sport. Thanks for sharing and Thumbs up!

  • @Up4Excel
    @Up4Excel 5 років тому +1

    Great use for power query. Thanks for the tips on choosing the right website upfront and cleaning the data.

  • @dailyuploads3959
    @dailyuploads3959 6 місяців тому

    how can you type the hyphon is that located on the 0 button in the keyboard. i try so many times to replace the hyhon (-) with minus (-) located on 0 button. that is not working. sir tell the button where is actually the hyphon is

  • @ConnectWithIsti
    @ConnectWithIsti 5 років тому +1

    Hi Chandoo
    How get all the records if webpage have paging. I can get the data of only 1st page through this technique, but data set is having muliple paging it didn’t work.

    • @chandoo_
      @chandoo_  5 років тому +2

      You can do it with parameterized web connection. Topic for next week. Please tell me about a link that has paginated tables so I can demo it.

    • @ConnectWithIsti
      @ConnectWithIsti 5 років тому

      I am working with one of the corporate company and i used to deal with internal web applications, in this day to day routine i am interactive with this type of data set with paging.
      It would be great help if you could do it from some public resource.
      Ps : Web application needs login details also.
      Regards
      Istiyak Shaikh

    • @ChandooD
      @ChandooD 5 років тому

      @@ConnectWithIsti Ok, I will come up with something :)

  • @AkaExcel
    @AkaExcel 5 років тому

    Thank You!