Query multi page web table

sitewolf

Active Member
Joined
May 4, 2012
Messages
287
Depending on when you go to this url (between Sunday and Thursday I guess), the table of football stats at this link will be multiple pages.
However, I can't for the life of me figure out how to query beyond page 1 because the url doesn't change (it doesn't even change from passing yards etc moving from table to table)
On some pages I used to be able to add things like print_row=9999 to the end of the url....doesn't work here. With Google Sheets even page 1 doesn't consistently pull in.


Is this something I can do with power query and I'm just missing how? Haven't used that much.
I'm on 365
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,087
https://sports.yahoo.com/nfl/stats/weekly/?sortStatId=PASSING_YARDS&selectedTable=2&week={"week":1,"seasonPhase":"REGULAR_SEASON"}
https://sports.yahoo.com/nfl/stats/weekly/?sortStatId=PASSING_YARDS&selectedTable=2&week={"week":2,"seasonPhase":"REGULAR_SEASON"}
 

sitewolf

Active Member
Joined
May 4, 2012
Messages
287
I thank you for that, but it's not multiple WEEKS I'm looking to grab, it's multiple PAGES for the current week.
In other words, there's 4 pages to that table as I type this....I'm looking to be able to pull all 4 pages in and thus far only getting page 1
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,087
Got it
I think you will need vba from source of this page (there are page numbers)
but I am not vba user so I can't help
 

Watch MrExcel Video

Forum statistics

Threads
1,114,110
Messages
5,545,993
Members
410,720
Latest member
SSL
Top