Unable to download complex tables data on webpage using Query
Closed
kl.rameet
Posts
2
Registration date
Tuesday April 25, 2017
Status
Member
Last seen
April 30, 2017
-
Apr 25, 2017 at 03:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 1, 2017 at 11:10 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 1, 2017 at 11:10 AM
Related:
- Unable to download complex tables data on webpage using Query
- Kmspico download - Download - Other
- Gta 5 download apk pc - Download - Action and adventure
- Milfy city download - Download - Adult games
- Microsoft store download - Download - App downloads
- Fifa 23 download - Download - Sports
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 25, 2017 at 11:30 AM
Apr 25, 2017 at 11:30 AM
Hi kl.rameet,
The way to do this is going to the Data ribbon and then clicking on From the web. Here you can input the url. After the site loaded, click on the small yellow Arrow and click on the Import button.
Best regards,
Trowa
The way to do this is going to the Data ribbon and then clicking on From the web. Here you can input the url. After the site loaded, click on the small yellow Arrow and click on the Import button.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 1, 2017 at 11:10 AM
May 1, 2017 at 11:10 AM
Hi kl.rameet,
Let me show you the file where I imported the site.
The company names are located in A108:A117.
Here is the file:
http://ge.tt/1MSt1uj2
Does this look the same for you?
Best regards,
Trowa
Let me show you the file where I imported the site.
The company names are located in A108:A117.
Here is the file:
http://ge.tt/1MSt1uj2
Does this look the same for you?
Best regards,
Trowa
Apr 30, 2017 at 11:41 AM
I am unable to get the first column (company name) using the webquery/power query.
Appreciate if you can try and help me with this.