Nov 06 2020 07:58 AM
hello
Is there a way in Power Query to transfer data from the web, the hyperlinked text is transferred to Power Query in the same conditions and works?
and for that how can i extract URL code from web for many items?
thanks for your attention
Nov 06 2020 09:06 AM
It is helpful to all of us to know your operating system and Excel version, as different approaches may be required depending on the version and OS. Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc and your operating system e.g. Win10 (2004), Win 10 (1903, Mac, etc.
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 06 2020 01:51 PM
If you mean to extract all hyperlinks from webpage, sample could be
Using Html.Table() To Extract URLs From A Web Page In Power BI/Power Query M
Web Scraping In Power BI And Excel Power Query – Part 2 – Extracting Links
I believe you could find more.
Nov 07 2020 07:50 AM
@NikolinoDE thanks for your attention
my office is 2019 and win 10
Nov 07 2020 08:39 AM
With the permission of all those involved,
I would like to provide you with this information in addition
to the very good and very interesting solution proposed by Mr.Sergei Baklan .
Import data from external data sources (Power Query)
us & ad = us
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Nov 07 2020 08:42 AM
Nov 07 2020 01:22 PM
Yes, sorry, Html.Table() is not available so far in Excel. Parsing of page as text which Gil suggested could work, but you shall to know which kind of links you'd like to extract and how to clean them.
Nov 07 2020 01:23 PM
@NikolinoDE , afraid just list of connectors won't help in this case.
Nov 08 2020 07:49 AM
Nov 08 2020 08:11 AM
Sorry, to try what? I really didn't catch.
Nov 08 2020 09:51 AM
Thanks Baklan
I was looking for a way to create an Excel file that extract all category of formula in excel from below link by power query, that I can update the ability to access all information and examples of formulas. if it possible help me to do it please.
https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26...