NHL.com website; How to get tables into PQ

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,221
Office Version
365
Platform
Windows
Can someone please help me?

I am trying to import this webpage to PQ but the Navigator lists no tables at all. Is there some special technique?

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.nhl.com/standings/2019/league

[/FONT]
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,440
Office Version
2019
Platform
Windows
I clicked on PQ and retrieve from Web and was able to load two tables. They were listed as Table 6 and Table 7. Not sure what issues your were having.
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,221
Office Version
365
Platform
Windows
Thanks for your reply, Allan.

All that the navigator shows is a yellow folder with
https://www.nhl.com/standings/2019/league [1] and under it an item called Document. There are no tables listed. What am I doing wrong? Is there some setting?
 
Last edited:

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,221
Office Version
365
Platform
Windows
Thanks Sandy. All I see is everything above your Table0.

P.S. how do I add screenshots?
 

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,221
Office Version
365
Platform
Windows
Excel 365 Insider Fast 1910 12126.2000
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,090
hm, so it should work properly

on my picture you can see Display Option and Refresh Icon, use it
 
Last edited:

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,221
Office Version
365
Platform
Windows
I refreshed, and refreshed...to no avail.
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,090
I am afraid you need to start again and again from the beginning, I mean: paste url , connect etc

maybe your internet speed is too slow , I really don't know
 

Watch MrExcel Video

Forum statistics

Threads
1,096,332
Messages
5,449,764
Members
405,575
Latest member
Masimo85

This Week's Hot Topics

Top