Unable to download complex tables data on webpage using Query
Closed
kl.rameet
TrowaD
- Posts
- 2
- Registration date
- Tuesday April 25, 2017
- Status
- Member
- Last seen
- April 30, 2017
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Unable to download complex tables data on webpage using Query
- Unable to download media in whatsapp - Guide
- Real downloader unable to download ✓ - Forum - Downloading
- Realplayer unable to download youtube ✓ - Forum - YouTube
- Copy pivot table data to another worksheet vba - Forum - Excel
- Unable to download attachment from yahoo mail in android - Guide
2 replies
TrowaD
Apr 25, 2017 at 11:30 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
May 1, 2017 at 11:10 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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.