Hi Guys,
I wish to bring a data from a website table (table on 289 pages), how I do it?
Thank you
Importing a Table from Webpage
- jonny
- Thread is marked as Resolved.
-
In the Data Tab of the ribbon there seveal options for getting data into Excel, one is From Web. Try that
-
Hello,
Believe you mean Importing a Table ....
Among the solutions, Power Query offers the greatest flexibility
see link : https://www.howtoexcel.org/pow…ebsite-using-power-query/
Hope this will help
-
Thank you, guys, looks as Power Query is the best solution.
However my website requires login credentials.
Without of it getting a screen:
When I am trying to log-in, getting another error:
-
Hello,
Have no experience on this topic : how PowerQuery is handling authentication ...
May be : https://docs.microsoft.com/en-…ry/handlingauthentication
Hope this will help
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!